SQL$HELP_OLD72.HLB  —  Predicates  CONTAINING Predicate
    A CONTAINING predicate tests whether or not the string expression
    specified in the second value expression is contained within the
    string expression specified by the first.

  containing-predicate =

  ---> value-expr -+-------+-> CONTAINING --> value-expr -->
                   +> NOT -+

    The CONTAINING predicate is not case sensitive.

    The CONTAINING predicate is sensitive to diacritical markings
    used in any Multinational Character Set. Therefore, a matches a,
    but neither matches á, à, ä, Á, À, Â and so on.

    In Spanish, ch and ll are treated as if they were unique single
    characters.

    If you use a collating sequence, the CONTAINING predicate
    will not be sensitive to diacritical markings used in any
    Multinational Character Set.
Close Help