Boolean operators
Operator that returns true or false as the result.
The AND operator compares two or more conditions and returns TRUE only if all conditions are true and FALSE if any condition is false.
Example 109.
TRUE AND TRUE returns TRUE.
TRUE AND FALSE returns FALSE.
The OR operator compares two or more conditions and returns TRUE if at least one condition is true and FALSE only if all conditions are false.
Example 110.
TRUE OR FALSE returns TRUE.
FALSE OR FALSE returns FALSE.
The NOT operator reverses the truth value of a condition.
Example 111.
NOT TRUE returns FALSE.
NOT FALSE returns TRUE.