Kevin,

Ric already gave you the correct syntax ... use * instead of % for the wildcard. I mentioned using single quotes to delineate, but that's SQL Server, not sure if it's the same with Access.

~~Bonnie



>Yes, against Access from within Vb.Net.
>
>What I want is something like:
>
>

>SELECT *;
>  FROM MyTable;
>  WHERE MyField LIKE "SomeVal"
>

>
>But I'm not totally sure of the 'LIKE' syntax.
>
>Thanks
>
>
>
>
>
>
>>Kevin,
>>
>>Are you running this query against an Access database? if so, the wildcard for access is * and not %
>>
>>-R!