Comparing to a string pattern
For a column 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:
*
*
To match the percent sign (%) or the underscore character (_) in a string, precede those 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 2013 BIRT iHub 2