Negation
NOT can be used in an expression to reverse the boolean value of a logical expression.
For example:
NOT lastname=’Brown’You can also precede an operator with NOT to negate the operator. For example:
num NOT BETWEEN 1 and 100 num NOT IN (1, 100)