Predicates and Search Condition

This section presents expanded syntax for each predicate that can be used in a search condition. It concludes with expanded syntax for search-condition:
idmscu
This section presents expanded syntax for each predicate that can be used in a search condition. It concludes with expanded syntax for
search-condition
:
  • predicate
    A predicate is an operand of a search condition. It expresses or implies a comparison operation.
  • search condition
    A search condition is a Boolean expression that yields a truth value. The operands of a search condition are predicates, and the operators are the logical operators AND, OR, and NOT. A search condition establishes a criterion for selecting rows from a table.