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 !!!! ----- Original Message ----- From: Agus Sudana To: [email protected] Sent: Tuesday, January 30, 2007 5:58 PM Subject: [Programmer-VB] SQL query like '%' dear all, caranya select transaksi yg type-nya berawalan "RFS","TWS","SFS","CRSFS" itu gmn? saya sudah coba "select * from tabel where type in ('RFS%','TWS%','SFS%','CRSFS%') and lokasi='C-FOND'" tapi gak ada nampilkan apa2.. help please.. agus __________________________________________________________ Don't pick lemons. See all the new 2007 cars at Yahoo! Autos. http://autos.yahoo.com/new_cars.html
