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:Escape a literal underscore, percent, or backslash character with a backslash character (\). Alternatively, use the following syntax:
|
|
Copyright Actuate Corporation 2012 |