Last Updated: 5/8/2026
There are two Boolean literals: TRUE and FALSE.
We support the following Boolean operations:
OR
The following truth table defines the OR operator:
| TRUE | FALSE | NULL | |
|---|---|---|---|
| TRUE | TRUE | TRUE | TRUE |
| FALSE | TRUE | FALSE | NULL |
| NULL | TRUE | NULL | NULL |
AND
The following truth table defines the AND operator:
| TRUE | FALSE | NULL | |
|---|---|---|---|
| TRUE | TRUE | FALSE | NULL |
| FALSE | FALSE | FALSE | FALSE |
| NULL | NULL | FALSE | NULL |
NOT
The following table defines the NOT operator:
| TRUE | FALSE |
|---|---|
| FALSE | TRUE |
| NULL | NULL |
IS FALSE
The following table defines the IS FALSE operator:
| TRUE | FALSE |
|---|---|
| FALSE | TRUE |
| NULL | FALSE |
IS NOT FALSE
The following table defines the IS NOT FALSE operator:
| TRUE | FALSE |
|---|---|
| FALSE | TRUE |
| NULL | TRUE |
IS TRUE
The following table defines the IS TRUE operator:
| TRUE | TRUE |
|---|---|
| FALSE | FALSE |
| NULL | FALSE |
IS NOT TRUE
The following table defines the IS NOT TRUE operator:
| TRUE | FALSE |
|---|---|
| FALSE | TRUE |
| NULL | TRUE |
Casting a string to a Boolean value produces the result true for any string which spells ‘true’ when converted to lowercase. Any other non-null string produces the result false.
<Callout type=“info”>
Notice that not all Boolean operations produce NULL results when an operand is
NULL.
</Callout>