makasih.... makasih.... Dyah ABGers 4 ever
Y!M : canopus_sirius ----- Original Message ----- From: "boy.lesmana" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Friday, January 06, 2006 10:50 AM Subject: RE: [indo-oracle] [tanya] where > 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: "hernawan" <[EMAIL PROTECTED]> To: "Dyah Madhurani Duana" <[EMAIL PROTECTED]> Sent: Friday, January 06, 2006 10:45 AM Subject: Re: [indo-oracle] [tanya] where > > > di substr(nama,1,4) aja > > select substr(yyyymm,1,4) from table; > -- -----------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/
