Saya sudah coba dan berhasil, saya coba dengan memakai table lain yg saya punya
dengan logika SQL yg sama
ex:
SELECT * FROM INVENTTABLE
WHERE (ITEMID LIKE '003%' OR
ITEMID LIKE '004%' OR
ITEMID LIKE '005%') AND
(DATAAREAID ='C05')
Sama kan dengan Logika yg dipakai di Sintax SQL ini :
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 7:58 PM
Subject: Re: [Programmer-VB] SQL query like '%'
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
