Skip to content
In Text fields, wildcard characters can be used in searches to widen the search criteria, or when the spelling of a name or the digits in a number is uncertain. You can use the following wildcard characters:
- Asterisk (*): Used in place of any number of characters (including letters, numbers, special characters, spaces, and null characters) in a specific position.
For example, if a Name search used *ander* as the search criteria in the Last Name field, then the results would include names such as Anders, Anderson, Andersen, Sanders, and Sanderson. - Question Mark (?): Used in place of a single character (including letters, numbers, special characters, spaces, and null characters) in a specific position. The question mark wildcard character can be used in Text fields and phone number fields.
For example, if a Name search used 801-555-7?56 as the search criteria in the Phone field, then the results would include phone numbers with the first six digits of 801-555, and the last four digits of 7156, 7256, 7356, and so on. - Pipe (|): Used to indicate that the values should be searched for using an OR operator.
For example, if a Name search used Bill|Will as the search criteria in the First Name field, then the results would include all Name records with either Bill or Will as the first name.
