HELPLIB.HLB  —  RDML72  Statements  MATCHING
    Lets you use the asterisk (*) and percent (%) pattern matching
    characters in combination with other symbols to test for
    the presence of a specified string anywhere inside a string
    expression.

    You do not have to use the pattern matching characters if the
    string you specify matches the data stored in the database
    exactly. (If the database field is defined as TEXT 10, the string
    you specify must be exactly ten characters.)

    Records are included in the record stream if the string specified
    by match expression is found within the string specified by the
    value expression. The character * matches any string that maps
    onto its position. The character % matches any character that
    maps onto its position. When MATCHING is preceded by the optional
    qualifier NOT, a record is included in the stream if the pattern
    string is not found within the target string.

    MATCHING is not case sensitive; it considers uppercase and
    lowercase forms of the same character to be a match.
Additional Information: explode extract
Examples Format
Close Help