Wildcards
Previous Topic  Next Topic 

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 hat 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.