Boolean Operations

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.

info

Notice that not all Boolean operations produce NULL results when an operand is NULL.