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