Comment on page

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

Logical-and &, and

Logical-or |, or

Last modified 1yr ago