masih blm bisa mncl nii.. yg mncl, msh byk lain lokasi, ky "C-SGPS" dll.. apa krn like-nya di pake-in "or" yah..??
--- Rony Wijaya <[EMAIL PROTECTED]> wrote: > 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. > > > ____________________________________________________________________________________ Now that's room service! Choose from over 150,000 hotels in 45,000 destinations on Yahoo! Travel to find your fit. http://farechase.yahoo.com/promo-generic-14795097
