MATCHES - Search String Matching

Syntax (Informix)

Beschreibung:

    MATCHES is used only with CHAR and VARCHAR field types. Folowing rules apply to the format string :
    ? (query) means all characters are allowed at this place;
    * (star) means all character combinations (more than one character too) are allowed at this place (wildcard);
    [characterset] the square brackets with the specifyed characterset allow only only a specifyed subset of characters at this place.

    Example:

SELECT *
 FROM tkunden
 WHERE kname MATCHES '?[AaOoUu]*';

Select all customers whith an 'A', 'a', 'O', 'o', 'U' or 'u' as the second character in the field kname.