"not like" query

B

Brad Hotlz

I need to filter a query with something on the order of:
not like "R*" and not like "T*" and not null
unfortunately, I believe there is no "not like" command in access other than
in ADP.

If I went the route of using <>, I would have to be explicit about each of
the 30 possibilities as the <> paramater does not accept a wildcard.

Suggestions?
 
B

Brendan Reynolds

'Not Like' works just find in MDBs, Brad.

SELECT tblTest.TestText
FROM tblTest
WHERE (((tblTest.TestText) Not Like 'r*' And (tblTest.TestText) Not Like
't*' And (tblTest.TestText) Is Not Null);
 
B

Brad Hotlz

"not like" does not work in a query

Brendan Reynolds said:
'Not Like' works just find in MDBs, Brad.

SELECT tblTest.TestText
FROM tblTest
WHERE (((tblTest.TestText) Not Like 'r*' And (tblTest.TestText) Not Like
't*' And (tblTest.TestText) Is Not Null);
Click to expand...
 
B

Brad Hotlz

My apologies - For some reason, which I have not yet figured out, the query I
was working on would not accept the "not Like" parameter. I created a new
query and it worked just fine.

Thank you.
 
Top