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

Copy
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.

Copy
not(SALES.COUNTRIES.COUNTRY_NAME = "Germany")