LIKE Query not working when run through VB?

Question

I am running a query thru VB using LIKE command and it should return a value but doesn't. When I run the program in DEBUG mode and grab the SQL query string via COPY and PASTE it into ACCESS the query qorks fine and retruns the record. Why does it not work?
here is a sample of the code:
sqlstring = "SELECT * FROM stone WHERE stone1 LIKE '*" & stone1var & "*' OR stone2 LIKE '*" & stone1var & "*'"

and the copied string is pasting like this:

SELECT * FROM stone WHERE stone1 LIKE '*2-1-222*' OR stone2 LIKE '*2-1-222*'


Can someone help please???

Answer 1

In VB, you use % instead of *:

SELECT * FROM stone WHERE
stone1 LIKE '%2-1-222%' OR
stone2 LIKE '%2-1-222%'

The * will really works in ACCESS but not in VB.

Cheers!

Answer 2

VB script language is very different from SQL script language. They are not compatible.