Allowable wildcard characters are %  and _

The percentage sign is used to represent any number of characters.

The underscore symbol represents exactly one character.

Let's assume the database contains Dahl, Dahlk, Dahlton, Heyerdahl, Heyerdahlk, Heyerdahlen,  Udahl,  Udahlen, Udahlk,

If you submit:

Submit Return Results
Dahl Dahl
Dahl_ Dahl and Dahlk
Dahl% Dahl, Dahlk andDahlen
_Dahl Dahl and Udahl
%Dahl Heyerdahl, Udahl and Dahl
_Dahl_ Udahl, Dahl and Dahlk
_Dahl% Dahl, Dahlk, Dahlen, Udahl, Udahlk and Udahlen
%Dahl_ Dahl, Dahlk,  Udahl, Udahlk, Heyerdahl and Heyerdahlk
%Dahl% Dahl, Dahlk, Dahlen, Udahl, Udahlk, Udahlen, Heyerdahl, Heyerdahlk and Heyerdahlen

 

If the and radio button  is enabled and you search for Dahl, Jessie, only records that contain both Dahl and Jessie will be returned.

If the or radio button  is enabled and you search for Dahl, Jessie you will receive:

 

All searches will search: