Any access db /vbscript experts out there?

using ms acess db to store articles.

Developing a search page using an SQL "like" statement, but geting no results found.

if I use an "=" in place of the like, and set a definite search param like

select * FROM table where RFID = 1

this will work perfectly.

BUT

If i say

select * FROM table where RFID LIKE 1

any suggestions?

I was thinking its either a recordset cursor issue, OR, some setting in the access DB is off.

 

you need % for like. it's an sql wildcard. % before is wild before, % after is wild after, so surround your search string with % on both sides to make it work.

 

select *from table where RFID like '%1%';


syntax when using like.

 

looks like he's querying a numeric field so he wouldn't use the apostrophes.

 

sorry guys, it IS a txt fields, that was used for sake of simplicity in the example.....

I think the % blah % will do it. I KNEW that, but must have overlooked it. Thanks for all your help, and i'll post back with the results later today when I test it at the office.

thanks!

 

cool - good luck

VG

 

good luck.

 

Hi i am new service provider.