Skip to main content
Previous sectionNext section

SQL Predicate Conditions

  • Overview of Predicates – Describes logical conditions that evaluate to either true or false.
  • ALL – Matches a value with all corresponding values from a subquery.
  • ANY – Matches a value with at least one matching value from a subquery.
  • BETWEEN – Matches a value to a range of values.
  • %CONTAINS – Matches a value to one or more phrases using word-aware matching.
  • %CONTAINSTERM – Matches a value to one or more words using word-aware matching.
  • EXISTS – Checks a table for the existence of at least one corresponding row.
  • %FIND – Matches a value to a set of generated values with bitmap chunks iteration.
  • FOR SOME – Determines whether to return a record based on a condition test of field values.
  • FOR SOME %ELEMENT – Matches list element values or the number of list elements with a predicate.
  • IN – Matches a value to items in an unstructured comma-separated list.
  • %INLIST – Matches a value to the elements in a %List structured list.
  • %INSET – Matches a value to a set of generated values.
  • IS JSON – Determines if a data value is in JSON format.
  • IS NULL – Determines if a data value is NULL.
  • LIKE – Matches a value with a pattern string containing literals and wildcards.
  • %MATCHES – Matches a value with a pattern string containing literals, wildcards, and ranges.
  • %PATTERN – Matches a value with a pattern string containing literals, wildcards, and character type codes.
  • SOME – Matches a value with at least one matching value from a subquery.
  • %STARTSWITH – Matches a value with a substring specifying initial characters.