SQL LIKE wild card

  • Thread starter Thread starter Guest
  • Start date Start date
G

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'
 
gene said:
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'
Click to expand...

Try the * instead of %. It's also ? instead of _.
 
Yes. See Help under "Like Operator". You have to use
double quotes and a "?" for the single character wildcard
inside the double quotes.
 
Back
Top