Kalau dikasih kurung gimana? "select * from tabel where (type like 'RFS%' or type like 'TWS%' or type like 'SFS%' or type like 'CRSFS%') and (lokasi='C-FOND')"
----- Original Message ----- From: Agus Sudana To: [email protected] Sent: Tuesday, January 30, 2007 6:47 PM Subject: Re: [Programmer-VB] SQL query like '%' alow, slm kenal jg. udh sy coba,tp kog yg mncl lokasinya g cuma di "C-FOND" yah..? muncul jg "WH-G". ada yg slh..? thanx agus --- Rony Wijaya <[EMAIL PROTECTED]> wrote: > Salam kenal, > Setahu saya di SQL pake perintah like, kalau pake perintah in maka isi yg > didalamnya harus lengkap dan tanpa % > maka jadinya seperti ini : > > "select * from tabel where type like 'RFS%' or > type like 'TWS%' or > type like 'SFS%' or > type like 'CRSFS%' and > lokasi='C-FOND'" > > Selamat mencoba !!!! > __________________________________________________________ Any questions? Get answers on any topic at www.Answers.yahoo.com. Try it now.
