Skip to main content

Logical operators

OperatorExpression & Description
ANDboolean1 AND boolean2
Logical AND.
TRUE if both boolean1 and boolean2 are TRUE.
ORboolean1 OR boolean2
Logical OR.
TRUE if either boolean1 or boolean2 is TRUE.
NOTNOT boolean
Negates value.

Example

aba AND ba OR bNOT a
TRUETRUETRUETRUEFALSE
TRUEFALSEFALSETRUEFALSE
TRUENULLNULLTRUEFALSE
FALSEFALSEFALSEFALSETRUE
FALSENULLFALSENULLTRUE
NULLNULLNULLNULLNULL

Help us make this doc better!