A logical predicate tests an operand against one or more other operands to evaluate to a logical (Boolean TRUE, FALSE, or UNKNOWN) result.
The tested operand can be one of the following:
- A column name
- A literal
- An arithmetic expression
- A Period expression, including a derived period
- The DEFAULT function
- A built-in function such as CURRENT_DATE or USER that evaluates to a system variable