Filter Symbols

Oracle is used as the basis for the Set Filter function, and some special characters should be used carefully.

Special characters that should be used with caution in a filter:


Symbol	Issue
% (Percent symbol)	Oracle perceives the percent sign as a wildcard. When the percent sign is entered as filtering criteria, the results are not filtered.
_ (Underscore)	The following occurs when using underscores in a filter: No filtering occurs if you set a filter with only an underscore. Inserting an underscore before or after characters (e.g., _abc, abc_, or _abc_) returns all records that contain the underscore character. Inserting an underscore between characters (i.e., a_b or a_b_c) returns records that contain the characters presented in the designated order that have any single character between them.