"not like" query

[Guest]

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?

 

[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);

 

[Guest]

"not like" does not work in a query

'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);

 

[Guest]

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.