Wildcards

 

A wildcard character can be used to substitute for any other character or characters in a search string.  DMS uses the SQL wildcards where the percent sign (%) matches zero or more characters, and underscore (_) a single character.

Hints on searching text fields in DMS:

1.To look for a field that starts with ABC you would use ABC%.

2.To look for a field that contains ABC you would use %ABC%.

3.If searching Note fields (i.e. Job Notes or user field notes) surround the text by the % symbols as in %find this%.

4.To find multiple items in a text or note field, you would use multiple %.  For example, to find ABC, DEF, and XYZ you would use %ABC%DEF%XYZ%.

5.The underscore character can be used as a single character wildcard.  So to find A?B where ? is one character, you would use A_B.  The search would return items such as ABB, ACB, etc, but not ACCB, or ACDB. To find these later combinations of characters, you would use A%B.