Boolean operators

EQL supports the Boolean operators AND, OR, and NOT.

The results of Boolean operations (including the presence of NULL) is shown in the following tables:

Results of NOT operations:

Value of x	Result of NOT x
TRUE	FALSE
FALSE	TRUE
NULL	NULL

Results of AND operations:

Value of x	Value of y	Result of x AND y
TRUE	TRUE	TRUE
TRUE	NULL	NULL
TRUE	FALSE	FALSE
NULL	TRUE	NULL
NULL	NULL	NULL
NULL	FALSE	FALSE
FALSE	TRUE	FALSE
FALSE	NULL	FALSE
FALSE	FALSE	FALSE

Results of OR operations:

Value of x	Value of y	x OR y
TRUE	TRUE	TRUE
TRUE	NULL	TRUE
TRUE	FALSE	TRUE
NULL	TRUE	TRUE
NULL	NULL	NULL
NULL	FALSE	NULL
FALSE	TRUE	TRUE
FALSE	NULL	NULL
FALSE	FALSE	FALSE

For information on order of operations, see Operator precedence rules.