Truth Tables

For Boolean Operators: AND, OR, XOR, NOT

For Conditional Operators: [NOT] BETWEEN, [NOT] IN, [NOT] LIKE, IS [NOT] $NULL

Truth Table for a Boolean AND Expression

expression1 AND expression2

If the conditional expressions linked by AND are

Truth Table for a Boolean OR Expression

expression1 OR expression2

If the conditional expressions linked by OR are

Truth Table for a Boolean X OR Expression

expression1 XOR expression2

If the conditional expressions linked by XOR are

Truth Table for a Boolean NOT Expression

NOT expression1

If the conditional expression preceded by NOT is

Truth Table for a [NOT] BETWEEN Expression

expression1 [NOT] BETWEEN expression2 AND expression3

A BETWEEN comparison is TRUE when

A NOT BETWEEN comparison is TRUE when

The [NOT] BETWEEN comparison is FALSE in all other circumstances.

Truth Table for a [NOT] IN Expression

expression1 [NOT] IN (expression2 [«,expression3 »])

An IN comparison is TRUE when

A NOT IN comparison is TRUE when

The [NOT] IN expression is FALSE in all other circumstances.

Note: Comparison ends as soon as a TRUE instance is found.

Truth Table for a [NOT] LIKE Expression

expression [NOT] LIKE pattern

A LIKE comparison is TRUE when

A NOT LIKE comparison is TRUE when

The [NOT] LIKE expression is FALSE in all other circumstances.

Truth Table for an IS [NOT] $NULL Expression

expression IS [NOT] [$]NULL

An IS $NULL comparison is TRUE when

An IS NOT $NULL comparison is TRUE when

The IS [NOT] $NULL expression is FALSE in all other circumstances.