colums that contain a word 1

[SharonMee]

Hi all:

How do I set up a query, such that it will give me all rows available in my table except for those in which column "Check" has the word "Total".

Thanks for helping again

 

[lespaul]

SELECT * FROM MYTABLE WHERE CHECK <> "Total"

Leslie

 

[SharonMee]

I tried this:

SELECT * FROM MYTABLE WHERE [CHECK] <> "Total"
and it's still giving me rows with the word Total in the column Check. I should say that in the column I could have something like "001023 Total". I don't want this row to be included in the query.

Thanks for helping, leslie

Sharonmee

 

[lespaul]

ok then:

SELECT * FROM MYTABLE WHERE [CHECK] NOT LIKE "*TOTAL*"

Leslie