Wildcard Searching

Wildcard searching operates slightly differently depending on whether Generic Search Server (GSS) or database searching is used.

Table 1. Wildcards for database searching
Character Used Description
%

A substitute for zero or more characters .

Multiple character wildcard searches looks for 0 or more characters. For example, to search for test, tests or tester, you can use the search: test%

_

A substitute for exactly one character.

Table 2. Wildcards for Generic Search Server
Character Used Description
*

To perform a multiple character wildcard search.

Multiple character wildcard searches looks for 0 or more characters. For example, to search for test, tests or tester, you can use the search: E.g. test*

You can also use the wildcard searches in the middle of a term. E.g. te*t

?

To perform a single character wildcard search.

The single character wildcard search looks for terms that match that with the single character replaced. For example, to search for "text" or "test" you can use the search: E.g. te?t

Note: Generic Search Server uses Apache Lucene support for single and multiple character wildcard searches. You cannot use a * or ? symbol as the first character of a GSS\Lucene search. For more information on Global Search Services please refer to Cúram Generic Search Server.