Upper- and lower-case characters are treated the same, so "a" will match "A" and vice-versa. The Basic method uses two wildcard symbols, ? and *. ? matches any single character, and * matches any string of characters. The given pattern must match at word boundaries in the associated data field.

So, for example, the pattern wood will match a surname of "Wood", but not "Atwood" or "Woodbury". The pattern wood* will match "Wood" or "Woodbury", but not "Atwood". The pattern *wood* will match "Atwood", "Wood", and "Woodbury".

Basic Method Symbols: ? Matches any single character Sm?th matches "Smith" and "Smyth". * Matches any string of characters. Wood* matches "Wood" and "Woodbury".


+/- +/-