>>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 *
Merci.
Is that because of how OLEDB is built?
Ben Rail
Business Solutions
LOGI.design