SQL LIKE wild card

[Guest]

Does Access query (SQL) suppoer the wild card $ with LIKE to select records?
I get no erros but the query returns no results,
Example: SELECT * FROM table WHERE name LIKE '%smith'

 

[Rick Brandt]

Does Access query (SQL) suppoer the wild card $ with LIKE to select records?
I get no erros but the query returns no results,
Example: SELECT * FROM table WHERE name LIKE '%smith'

Try the * instead of %. It's also ? instead of _.

 

[owenc]

FOR ACCESS SQL

SELECT * FROM table WHERE name Like "*smith"

 

[GRayL]

Yes. See Help under "Like Operator". You have to use
double quotes and a "?" for the single character wildcard
inside the double quotes.