A search condition, or conditional expression, consists of one or more conditional terms connected by one or more of the following logical predicates:
- Comparison operators
- BETWEEN/NOT BETWEEN
- LIKE
- IN/NOT IN
- ALL or ANY/SOME
- EXISTS/NOT EXISTS
- OVERLAPS
- IS NULL/IS NOT NULL