Skip to main content

This is documentation for Caché & Ensemble. See the InterSystems IRIS version of this content.

For information on migrating to InterSystems IRIS, see How to Migrate to InterSystems IRIS, available on the WRC Distributions page (login required).

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.
Feedback