jelas aja yang muncul cuma lokasi C-FOND kan di where-nya emang ada lokasi='C-FOND' bukan begitu bukan?? apa gue salah nangekep??
oya ampe lupa.. salam kenal juga. At 19:58 1/30/2007, you wrote: >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 > > >Wahana Programmer Groups Links > >Yahoo! Groups Links > > > > > > >-- >No virus found in this incoming message. >Checked by AVG Free Edition. >Version: 7.5.432 / Virus Database: 268.17.14/658 - Release Date: >1/29/2007 14:49 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.432 / Virus Database: 268.17.14/658 - Release Date: 1/29/2007 14:49
