...

Use the ESCAPE clause to disable the special semantics given to the characters ( _ ) and
( % ). The escape character specified must precede the special characters in order to disable their
special semantics.

Syntax
Notes • The column_name specified in the LIKE predicate can be a column, a string constant, or an
arbitrary character expression (such as SUBSTRING or LTRIM).
• The string_constant may be a string constant or a scalar function call.
• The escape_character must be a one character string constant.
• A percent sign ( % ) in the pattern matches zero or more characters of the column string.
• A underscore symbol ( _ ) in the pattern matches any single character of the column string.

Example This example illustrates three ways to use the LIKE predicate:
In the first LIKE clause, for all strings with the substring ’Computer’ the predicate evaluates to
true. In the second LIKE clause, for all strings which are exactly three characters long the
predicate evaluates to true. 

In the third LIKE clause the backslash character ( \ ) is specified as
the escape character, which means that the special interpretation given to the underscore
character ( _ ) is disabled. The pattern evaluates to TRUE if the item_name column has embedded
underscore characters.

column_name [ NOT ] LIKE string_constant [ ESCAPE escape_character ]

cust_name LIKE ’%Computer%’
cust_name LIKE ’___’
item_name LIKE ’%\_%’ ESCAPE ’\’