Problems firing LIKE Queries in Access 1

[MarkRuse]

Help,<br>
<br>
I have a problem firing a SELECT Query with a Like clause in it at an Access 97 Database. ie 'SELECT Name FROM Customer WHERE Name Like '*BOB*'.<br>
<br>
If I fire the SQL in the Database window it works fine, but when I Attempt to <br>
<br>
.Open SQL , Connection ,1 ,1<br>
<br>
It comes back with an error message saying that it doesn't like the like clause (ha ha)<br>
<br>
Can anybody help me with this ?<br>
<br>
Also does anybody know how to pass in Parameters to an Access Query fired from VBScript. I have tried many different combinations, and nothing seems to work.<br>

 

[BillWebboy]

Check your wildcard symbol. Using VBScript, the wildcard symbol for LIKE is the percent sign (%),...use that instead of the asterisk and it should work...

 

[MarkRuse]

Thanks BillWebboy, worked like a treat. I think I got confused because Access only likes using the * as a wildcard.