>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 :)
If things have the tendency to go your way, do not worry. It won't last. Jules Renard.