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:
% matches zero or more characters. For example, %ace% matches any value that contains the string ace, such as Ace Corporation, facebook, Kennedy Space Center, and MySpace.
_ matches exactly one character. For example, t_n matches tan, ten, tin, and ton. It does not match teen or tn.
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\\%