Wildcards

Use wildcards in a search term to represent one or more other characters. The two most commonly used wildcards are:

1) Use "_" to represent a single alphanumeric character in a search expression. For example, searching for "Tr_ck" returns records that contain "Truck" or "Track".

2) Use "%" to specify zero, one, or many alphanumeric characters. For example, searching for "Tr%" returns records that contain "Truck", "Tractor", "Tree" or "Trolley".

Note: Wildcards are intended to be used with a value. Searching a wildcard with no associated value will return any results that have values in that field. For example, searching for an Asset ID of "%" in the Asset Chooser will return any Asset that contains a value in the Asset ID field.