NOT

All functions > LOGICAL > NOT

Returns TRUE if the argument is false.

Signatures

Returns: TRUE if the expression is FALSE, FALSE if the expression is TRUE

NOT(expr1: BOOLEAN) → BOOLEAN

Notes

• Logical NOT operator for boolean expressions
• Negates the boolean value of the expression
• Returns TRUE if the operand is FALSE
• Returns FALSE if the operand is TRUE
• NULL handling: Returns NULL if the operand is NULL
• Can be combined with other logical operators
• Commonly used to invert conditions in WHERE clauses
• Syntax: NOT expr or !expr (in some contexts)

See also

• Operators