>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


Hi Marc

Here's what ODBC help states about the like clause (there are more limitations).

A LIKE used in a procedure is supported only with constant patterns. The Desktop Database Drivers support SQL 92 LIKE pattern matching.

Had to read it twice too, but finally I think it corresponds to your predicament.

HTH,

Marc :)