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.
• EXISTS – Checks for the existence of a given object.
• %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.