Mysterious Query Results

[LynnEsther]

I am at a loss. I have a very simple query with the following criteria: Field1 <> "ABC". Problem is, in addition to returning records where Field1 <> ABC, it is also returning records where Field1 is not null. I don't understand why my query would exclude records that I'm not explicitly asking it to exclude. Any thoughts?

 

[gemma-the-husky]

it is correct isnt it?

the expression

field1 unequal to "ABC" returns everything other than "ABC"

nulls are problems, because a null cannot be compared to anything, so field1<>"ABC" will still return false for a null, I think.


===========
to include nulls you would have to say

<>"ABC" OR NULL

=============

do you mean

not(field1 in ("A","B","C")) perhaps