The use of wildcard characters in the TIMS3 Data Manager follows the conventions used by Microsoft Access. It is used for text field to easily locate matching or closely matching records. The more commonly used wildcard characters are described below:
|
Character |
Description |
Example (using the Document Title field) |
|
* |
Matches any number of characters. Can be used anywhere in the character string |
Roof* finds all titles beginning with "Roof". *Roof* find all titles with "Roof" anywhere in the field |
|
? |
Matches any single alphabetic character |
Highway ?? Route Plan finds all titles with a 2-character highway designation |
|
# |
Matches any single numeric character |
Highway ## Route Plan finds all titles with a 2-number highway designation |
|
[ ] |
Matches to one of the characters listed within the brackets |