Wild card replaces one or more characters in a search string.
Example:
If you want to find all user whose last name start with an S, you add a wild card to the search string that will replace all characters after the S.
the string to enter will be S% or S*.
Wildcard |
Description |
|---|---|
% or * |
A substitute for zero or more characters. |
_ |
A substitute for a single character. |
[character list] |
Sets and ranges of characters to match. Use this to find an underscore in e.g. the Terminal ID. Set the filter to BA[_]% to find all terminal that start with BA_ Use a – (minus sign) to set a range of characters. E.g., [a-c]% to find all users that start with an a, b, or c. |
[^character list] |
Matches only characters NOT specified within the brackets. This can be replaced with the Not Like operator. |
| Note: Filtering on _* to get all records that start with an underscore will give an empty result. In this case you have to "Escape" the underscore. Use [_]* or ^_* to get a correct result |
