an SQL query to search partial matches

A

aa

what would be syntax for an SQL query to search partial matches, compatible
with Access?
I tried WHERE (fieldname LIKE "something") - it did not cause an error, but
returns an empty recordset though there are entries in the field containing
"something" as substring
 
M

MH

WHERE MyField LIKE "*MySubstring*"

The asterix is a wildcard character that represents any number (or none) of
characters.

MH
 
Top