Coba '*' didepan & dibelakang 'BUDI' diganti '%' jadi: "SELECT * FROM SPRDDIL WHERE NAMA LIKE '%BUDI%'"
--- In [email protected], arif ipul <[EMAIL PROTECTED]> wrote: > > Dear rekan2 vb............ > Saya punya query sbb: > "SELECT * FROM SPRDDIL WHERE NAMA LIKE '*BUDI*'" > > gimana caranya pwncarian kata "BUDI" melalui textbox, aq sudah mencoba query seperti ini : > > "SELECT * FROM SPRDDIL WHERE NAMA LIKE ' *" & txtnama & "*' > > tapi hasilnya gagal......... > > mohon bantuannya.... > > > > > ____________________________________________________________________________________ > Be a better friend, newshound, and > know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ >
