If searching on constituent records, in the name field, use the * or ? wild cards. (The same holds true for any type of record allowing wild cards.)

For example, enter Sm?th to find Smith and Smyth. Select Begins with and enter Jo* to find all names starting with the letters j and o, such as Jones, Johnson, and Joseph.

Edit Field Criteria

Note: Unmark the Exact Match option or the wild cards will not work.



They can also be used with the following operators in queries:
  • Begins With
     
  • Does Not Begin With
     
  • Like
     
  • Not Like
     
  • Contains

The wildcards are:

  • Question Mark (?): Use the question mark to replace a single character. For example, to find anyone with the Last Name of Smyth, Smith, etc., type Sm?th.
  • Asterisk (*): Use the asterisk to replace a series of characters. These wildcards work in the same way. For example, to find anyone with a last name beginning with Sm, type Sm*. For anyone with a name ending in son, type *son.
  • Brackets [ ]: Use the brackets to query on a range of characters or to locate several characters.  For example, use the criteria Last Name Begins with [A-C] to locate all records with a last name beginning with A, B, or C.

When using the brackets with a comma between characters, you are searching for records with the values listed. For example, the criteria Last Name Begins with [A, F, G] selects all records with a last name beginning with an A, F, or G.

Note: Only one character should be specified when using Brackets and the Begins With operator, as in the example provided. To search on more than one character, use another wildcard option. For example:

Surname Begins with Ab*

OR Surname Begins with Al*

The above example will list all surnames that begin with the 2 characters specified.

Note: Wildcards functionality is not currently available in the NXT webview