Query question

[rhonda11]

I need to run a query that'll show me all records accept anything that start with "AES". Can somebody help me on this? Thanks in advance.

 

[mwolf00]

SELECT * FROM myTable WHERE left(field1,3) <> &quot;AES&quot; Get the Best Answers! faq333-2924
Merry Christmas!
mikewolf@tst-us.com
[santa2]

 

[Creepers]

Try in your Where clause

Not Like &quot;*AES*&quot;

 

[chrissie1]

something like this should do it


SELECT Table1.columnname
FROM Table1
WHERE (((Table1.columnname) NOt Like &quot;AES*&quot)

 

[chrissie1]

I see we all tried to help at the same time