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