SQL$HELP_OLD72.HLB  —  Predicates  MATCHING Predicate
    A MATCHING predicate searches character string literals for
    pattern matches. The pattern string accepts the following pattern
    characters:

    o  * Matches any string of zero or more characters

    o  % Matches any single character

  matching-predicate =

  ---> value-expr  -+------+-> MATCHING ------> <pattern>
                    +> NOT +

  pattern =

  ----> char-value-expr ---->

    Usage Notes

    o  If either of the expressions is null, the result is null.

    o  MATCHING predicate is not case sensitive; it considers
       uppercase and lowercase forms of the same character to be a
       match.

    o  The MATCHING predicate is not sensitive to diacritical
       markings used in the DEC Multinational Character Set.

    The following example shows the use of the MATCHING clause.

    SQL> select last_name
    cont> from employees
    cont> where last_name matching '%on*';
     LAST_NAME
     Connolly
     Lonergan
    2 rows selected
    SQL>
Close Help