Truth Tables
Documentation | Blog | Demos | Support
Truth Tables
5 out of 5 stars
1 rating
5 Stars | 100% | |
4 Stars | 0% | |
3 Stars | 0% | |
2 Stars | 0% | |
1 Stars | 0% |
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
- both TRUE, then the Boolean expression is TRUE.
- both FALSE, then the Boolean expression is FALSE.
- one TRUE and one FALSE, then the Boolean expression is FALSE.
Truth Table for a Boolean OR Expression
expression1 OR expression2
If the conditional expressions linked by OR are
- both TRUE, then the Boolean expression is TRUE.
- both FALSE, then the Boolean expression is FALSE.
- one TRUE and one FALSE, then the Boolean expression is TRUE.
Truth Table for a Boolean X OR Expression
expression1 XOR expression2
If the conditional expressions linked by XOR are
- both TRUE, then the Boolean expression is FALSE.
- both FALSE, then the Boolean expression is FALSE.
- one TRUE and one FALSE, then the Boolean expression is TRUE.
Truth Table for a Boolean NOT Expression
NOT expression1
If the conditional expression preceded by NOT is
- TRUE, then the Boolean expression is FALSE.
- FALSE, then the Boolean expression is TRUE.
Truth Table for a [NOT] BETWEEN Expression
expression1 [NOT] BETWEEN expression2 AND expression3
A BETWEEN comparison is TRUE when
- expression1 is equal to or greater than expression2 and equal to or less than expression3
A NOT BETWEEN comparison is TRUE when
- expression1 is less than expression2
- expression1 is greater than expression3
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
- expression1 is equal to one or more of the expressions listed in parentheses
A NOT IN comparison is TRUE when
- expression1 is not equal to any of the expressions listed in parentheses
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
- expression matches pattern.
A NOT LIKE comparison is TRUE when
- expression does not match pattern
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
- expression evaluates to $Null
An IS NOT $NULL comparison is TRUE when
- expression does not evaluate to $Null
The IS [NOT] $NULL expression is FALSE in all other circumstances.
5 out of 5 stars
1 rating
5 Stars | 100% | |
4 Stars | 0% | |
3 Stars | 0% | |
2 Stars | 0% | |
1 Stars | 0% |