Built-in Functions → not
not() is a boolean function that returns the negation of its expression argument. It first evaluates the expression. If the expression evaluates to true, it returns the opposite, or false. If the expression evaluates to false, it again returns the opposite, or true.
Signature
not (bool expr)
- expr :
bool
expression
Returns
bool
Example
Evaluate the expression COUNTRY_NAME and determine if it is equal to the string "Germany". If it is equal, return false, otherwise, return true.
not(SALES.COUNTRIES.COUNTRY_NAME = "Germany")