Just in case you have not found that the _ is used the same way as a single character.
HTH
Jeff
>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
It's Time to get a gun.
That's what I've been thinkin.
I think I can afford one, If I do a little less Drinkin.www.TrueGeeks.com