M
Maileen
Hi,
I wrote a simple table with few records inside.
I want to select all records where 'test' string doesn't exist.
for that i wrote the following query but it returns me an empty set
everytime. And i'm sure that some data should be returned.
Query :
SELECT *
FROM TestTable
WHERE TestName <> '%test';
it works under Oracle or MS SQL, so why it doen't work under MS Access
2002 ?
thanks,
Maileen
I wrote a simple table with few records inside.
I want to select all records where 'test' string doesn't exist.
for that i wrote the following query but it returns me an empty set
everytime. And i'm sure that some data should be returned.
Query :
SELECT *
FROM TestTable
WHERE TestName <> '%test';
it works under Oracle or MS SQL, so why it doen't work under MS Access
2002 ?
thanks,
Maileen