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)
Related concepts