problems with sql query and searching access db like

[gwrman]

I have a DB that I am trying to wrtie a VBscript search code for. I cant getany records to returned, even when I put in a term that I KNOW is in there. It DOES when I use "=" but when I use "LIKE" i get no results. Is there something I must do with the DB (setting?), or with the cursor in my vbscript code to get this to work?

 

[DotNetGnat]

can you post your sql query...

-DNG

 

[BDC2]

Access uses different wildcards to SQL, so in Access you query should be:

select * from table where field like "*substring*"

BDC.

 

[ChrisHirst]

wildcards in SQL are % not *

Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.
People Counting Systems

So long, and thanks for all the fish.

 

[Tarwn]

Chris: It depends on how your connecting. At one point I can remember using nothing but *'s for MS Access. Now % works. I don't know if this is something that changed with newer OLEDB drivers or if it is an OLEDB vs ODBC thing. One of those things I always meant to try and never got around to

So it is possible that *'s will work in this situation, I just couldn't tell you defintively since I don't know what method/version requires *'s and what uses %'s.