Logical operators
Operator | Expression & Description |
---|---|
AND | boolean1 AND boolean2 Logical AND. TRUE if both boolean1 and boolean2 are TRUE. |
OR | boolean1 OR boolean2 Logical OR. TRUE if either boolean1 or boolean2 is TRUE. |
NOT | NOT boolean Negates value. |
Example
a | b | a AND b | a OR b | NOT a |
---|---|---|---|---|
TRUE | TRUE | TRUE | TRUE | FALSE |
TRUE | FALSE | FALSE | TRUE | FALSE |
TRUE | NULL | NULL | TRUE | FALSE |
FALSE | FALSE | FALSE | FALSE | TRUE |
FALSE | NULL | FALSE | NULL | TRUE |
NULL | NULL | NULL | NULL | NULL |