NOT

All functions > LOGICAL > NOT

Returns true if the argument is false.

Syntax

NOT(expr1)
sql

Arguments

ParameterTypeRequiredDescription
expr1BOOLEANYesBoolean expression to negate

Returns

TRUE if the expression is FALSE, FALSE if the expression is TRUE

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

Suggest changes to this page
Last update at: 2025/10/13 10:23:46