Wildcard characters can be entered in manually to filter lookup records. The wildcard characters are:
Asterisk * to represent zero or more of any character
Underscore _ to represent exactly one character
The following examples illustrate the use of the * and _ wildcards…
*b finds records ending with b
*b* finds records containing b
b* finds records beginning with b
_b* finds records whose second character is b
_ab*c finds records where the second and third characters are a and b respectively and whose last character is c