Where expression confusion. 1

[DataHugger]

I have a query that I thought I wrote right, but since it isn't working correctly I must be wrong in my syntax, but I don't even know where to look to correct my SQL grammar.

So if any one could drop a quick line to answer this very green question it would be helpful or even if you think that I should look it up where do I look?

For me the query below will return the ID and RANGE where there is a RANGE and the RANGe is not equal to the string "Not Available"

Where am I wrong?


select ID, RANGE
FROM table1
Where Range IS NOT NULL AND NOT Range = "Not Available";

 

[nego78]

select ID, RANGE
FROM table1
Where Range IS NOT NULL AND Range != "Not Available";


that should be correct

 

[DataHugger]

Why am I an idiot!

Thank you very much.