| | |
| | | ADM | Matches anything starting with ADM (ADMINISTRATIVE, ADMISSIONS)
|
| | %20 | Matches anything containing 20 (111-20-01, 200-01-01, 111-22-20)
|
| | J%SMITH | Matches anything starting with J and also containing SMITH
(Jane Smith, John Smith, Jon Alan Smithson)
|
| | ___20 | Matches anything with 20 in positions 4-5 (111-20-333, 99920111)
|
| | 5_6 | Matches anything with 5 in position 1 and 6 in position 3 (506-1234, 516-9999)
|