Automatic appending of wildcards

For some searches wildcard characters are appended, pre-pended or both to some search criteria. For example, for a person search if a user enters "Smith" the appended search criteria is "Smith%" which returns all persons with the name Smith. Without appending the % wildcard the search would return only exact matches on Smith. The following table outlines searches in the application and whether wildcard are automatically appended.

Table 1. Summary of application searches
  Database or GSS? Prepended Appended
Person Database No Yes
Person GSS No No
Employer Database No Yes
Employer GSS No No
Information Provider Database No Yes
Information Provider GSS No No
Product Provider Database No Yes
Product Provider GSS No No
Service Supplier Database No Yes
Service Supplier GSS No No
Utility Database No Yes
Utility GSS No No
Educational Institute Database No Yes
Educational Institute GSS No No
External Party Database No Yes
External Party GSS No No
External Party Office Database No Yes
All Participant Search Database No Yes
All Participant Search GSS No No
User Database Yes Yes
Organization Unit Database Yes Yes
Position Database No Yes
External User Database Yes Yes
Wait List Database Yes Yes
Work Queue Database Yes Yes