I'm using ODBC to perfrom SQL on a MS-Access database, and have encountered a problem with subqueries using a LIKE clause.

Here's the SQL...

SELECT A.* FROM TableA A
WHERE A.id IN
(
SELECT id
FROM TableA WHERE name LIKE 'O%'
)

If I change the % to a * then the query works but then the simpler case of running the simple query like this fails.
SELECT id
FROM TableA WHERE name LIKE 'O*'

Running the queries directly in Access work with the * notation but not the % notation. What is the ODBC Jet driver doing (its version 4.0 supposedly ANSI SQL-92 compliant)

Anyone tell me why and what a possible work around is??