>Hi All,
>
>I am using VB with 'Microsoft.Jet.OLEDB.4.0' to connect to ACCESS 2000.
>
>My problem is that everytime I use the LIKE Operator in my queries I get no records back.
>
>Should I avoid LIKE in queries through OLEDB 4 to Access tables?
>
>(BTW the query works perfectly when run directly from Access.)
You need to use the % wildcard instead of the *
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com