var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Access/ODBC 'LIKE' clause failure
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
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.
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??