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

WHERE MyField LIKE "*MySubstring*"

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

MH

"aa" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
>
>