LIKE( )
Tests if a string matches a pattern.
Syntax
LIKE(str, pattern)
str
The string to evaluate.
pattern
The string pattern to match. You must enclose the pattern in double quotation marks (" "). The match is case-sensitive. You can use the following special characters in a pattern:
*
*
To match a literal percent (%), underscore (_), precede those characters with two backslash (\\) characters. For example, to see if a string contains M_10, specify the following pattern:
"%M\\_10%"
Returns
True if the string matches the pattern; returns false otherwise.
Example
The following example returns true for values in the customerName field that start with D:
LIKE([customerName], "D%")
The following example returns true for productCode values that contain the substring Ford:
LIKE([productCode], "%Ford%")
The following example uses two LIKE( ) expressions to look for the substrings "Ford" or "Chevy" in each ProductName value. If a product name contains either substring, the computed column displays U.S. Model; otherwise, it displays Imported Model.
IF(((LIKE([ProductName], "%Ford%") = TRUE) OR (LIKE([ProductName], "%Chevy%") = TRUE)), "U.S. model", "Imported Model")

Additional Links:

Copyright Actuate Corporation 2013 BIRT iHub 2