Attempts to match a character expression to a character
pattern, which is a character string that includes one or more wildcards.
% matches any number (zero or more) of characters in the corresponding
position in first character expression.
_ matches one character in
the corresponding position in the character expression.
Any other
character matches only that character in the corresponding position in the
character expression. city LIKE 'Sant_'
To
treat % or _ as constant characters, escape the character with an optional
escape character, which you specify with the ESCAPE clause. SELECT a FROM tabA WHERE a
LIKE '%=_' ESCAPE '='
When LIKE comparisons are used, compares one character
at a time for non-metacharacters. This is different than the way processes
= comparisons. The comparisons with the = operator compare the entire character
string on left side of the = operator with the entire character string on
the right side of the = operator. For more information, see "Character-based
collation in " in
the .