LIKE operator
The LIKE operator is used in an expression such as:
column LIKE 'Mar%'
In this example, values of column, such as Mary or Martin, satisfy the test because both start with Mar.
A LIKE operator pattern must be a literal string, for example, 'abc%', a parameter, or an expression. The LIKE operator does not support column references, subqueries, or aggregate expressions. Other examples include:
column LIKE :paramState
column LIKE CURRENT_USER( )
The following rules apply:
*
*
*
Escape a literal underscore, percent, or backslash character with a backslash character (\). Alternatively, use the following syntax:
test_string LIKE pattern_string ESCAPE escape_character
The escape character must obey the same rules as the LIKE operator pattern.

Additional Links:

Copyright Actuate Corporation 2012