Help with Not Equal SQL Statement
Posted on 2007-10-17
I have the following code as part of one of my sql statements. I'm trying to account for all values in the field that are not equal to Yes, including Null values. For some reason, if the field has <NULL> in it, the statement doesn't work. If the field has 'No' or some other value besides 'Yes' it works fine. Do I need to change something to find Nulls as well? I was under the impression that <> 'Yes' would work. Please advise. Thanks!
AND [Has__bAPI__bMatch__bRun__Q]<> 'Yes'