Michael, Mark and Jeff,

Thanks. Your you are write, you have to put % i.o. *.

Wonder how much more gigabytes of help will be required to document such a quirk :).

Kind regards,

Marc


>>Hi,
>>
>>For some reason my application has to interact with an Access .MDB file. I use ODBC and ADO to interact with this .MDB.
>>
>>I cannot get the following sql statement to return values:
>>
>>select * from addresses where name like "*DAVID*"
>>
>>where Addresses is a table in the MDB and Name is a one of the fields in it.
>>
>>In Access, executing this selection does return records.
>>
>>Is it ADO, ODBC or me?
>>
>>TIA,
>>
>>Marc
>
>Marc,
>
>Try:
>select * from addresses where name like '%DAVID%'
>
>Regards,
>Mike