SQL$HELP_OLD72.HLB  —  Predicates  Quantified Predicate
    A quantified predicate compares a value with a collection of
    values. It has the same form as a basic predicate except that the
    second operand must be a column select expression preceded by an
    ALL, ANY, or SOME comparison operator.

  quantified-predicate =

  --> value-expr --+-> = --+-+-> ALL --+-> ( col-select-expr ) -->
                   +-> <> -+ +-> ANY --+
                   +-> ^= -+ +-> SOME -+
                   +-> != -+
                   +-> < --+
                   +-> <= -+
                   +-> > --+
                   +-> >= -+

    The following table describes the value of the result based on
    the comparison of values for the quantified predicate.

    Table 8 Quantified Predicate Result Table

    Comparison of Values        Result

    ALL Quantifier

    If all comparisons are      True
    True
    If any comparisons are      False
    False
    If no comparisons are       True
    made
    Otherwise                   Unknown

    SOME and ANY Quantifiers

    If any comparisons are      True
    True
    If all comparisons are      False
    False
    If no comparisons are       True
    made
    Otherwise                   Unknown
Close Help