I don't do access but give select * from addresses where name like "%DAVID%"
a try.
HTH
Jeff
>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
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