The following wildcard characters can be used as comparison criteria (criteria: Conditions you specify to limit which records are included in the result set of a query or filter.) for text filters, and when searching and replacing content.
| Use |
To find |
| ? (question mark) |
Any single character
For example, sm?th finds "smith" and "smyth" |
| * (asterisk) |
Any number of characters
For example, *east finds "Northeast" and "Southeast" |
| ~ (tilde) followed by ?, *, or ~ |
A question mark, asterisk, or tilde
For example, fy06~? finds "fy06?" |
United Kingdom
Printer-Friendly Version
Show All
Hide All
