Logical-not !, not

Operator: ! , not

The logical operator ! , not can be used to inverse a logical condition or boolean value (Yes/No). If the condition evaluates to unknown, the inverse is also (still) unknown.

The operators ! and not can both be used and are exactly the same.

This function is SQL compatible. For more information about SQL compatibility, see our documentation.

Returns a value that is the inverse of the original condition.

!condition

!True => No

! (true or false) => No

! (true and false) => Yes

! (unknownboolean) => unknown

! 123 => expression type mismatch

not condition

not True => No

not (true or false) => No

not (true and false) => Yes