Comparing to a string pattern
For a cell that contains string data, you can create a filter condition that compares each value to a string pattern instead of to a specific value. For example, to display only customers whose names start with M, use the Like operator, and specify the string pattern M%, as shown in the following filter condition:
Customer Like 'M%'
You can use the following special characters in a string pattern:
*
% matches zero or more characters. For example, %ace% matches any value that contains the string ace, such as Ace Corporation, facebook, and Kennedy Space Center.
*
To match the percent sign (%) or the underscore character (_) in a string, precede the characters with two backslash characters (\\). For example, to match S_10, use the following string pattern:
S\\_10
To match 50%, use the following string pattern:
50\\%

Additional Links:

Copyright Actuate Corporation 2012