NOT

Syntax

NOT(Boolean)

Description

Checks the Boolean arguments of a column and gives the opposite Boolean result.  If the argument is true the result is false. If the argument is false the result is true. If you enter null, the result is null.

Instead of using the NOT() function you can also use the ! operator.

Examples

Checks the column1 Boolean expression and gives the opposite result.

Column1Result
truefalse
truefalse
falsetrue
falsetrue
nullnull