Sebenernya tergantung isinya... Kalau isi datanya pasti 6 digit ( or at least 5 digit) dengan 4 digit pertama pasti tahun wherenya jadi
select * from nama_tabel where substr(nama_kolom,1,4) = '2005' -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Dyah Madhurani Duana Sent: 06 Januari 2006 10:18 To: [email protected] Subject: [indo-oracle] [tanya] where Permisi... Numpang tanya lg, nih! Maklum, bener2 newbie. Klo gw punya data yang tipenya char(6), isinya untuk year & month ( yyyymm). Nah, klo gw cuma mau tampilin data yg tahun 2005 aja, gimana ngambilnya, ya? gimana syntax "where"-nya? Makasih.... Dyah ABGers 4 ever Y!M : canopus_sirius [Non-text portions of this message have been removed] -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com Yahoo! Groups Links -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
