Additional Name Search Criteria Window

This window opens when you click the Add/Change button on the Name Search window and allows you to enter additional criteria on which to search. Any values previously entered in this window are displayed.

The following columns are available for you to enter additional criteria.  Also shown is an example of the criterion displayed in the Name Search window.

Column

Description

Example of Display

Middle Name

Can enter up to 15 alphanumeric characters; LIKE comparison

Middle Name LIKE 'Annette'

Nickname

Can enter up to 15 alphanumeric characters; LIKE comparison

Nickname LIKE 'Aly'

Gender

Select value from drop-down list; EQUALS comparison

Gender =' F'

Mobile Phone

Enter in 00000 (000) 000 0000 format; EQUALS comparison

Mobile Phone = 0000 (432) 987 6543

Addr Line 1

Can enter up to 60 alphanumeric characters; LIKE comparison

Addr Line 1 LIKE '222 Main Street'

City

Can enter up to 25 alphanumeric characters; LIKE comparison

City LIKE 'Roanoke'

ZIP Range

Can enter a single ZIP Code or a range up to 12 numeric characters; if you enter a range, the starting ZIP Code must be less than or equal to the ending ZIP Code; EQUALS or BETWEEN comparison

ZIP Range = '22212' To '23212'

Phone

Enter in 00000 (000) 000 0000 format; EQUALS comparison

0000 (432) 123 4567

Name Type

Select value from drop-down list; default is *ALL; EQUALS comparison

Name Type = *ALL

Addr Code

Select value from drop-down list; EQUALS comparison

Address Code = *LHP

DE Class Year

Can enter up to 4 numeric characters; default is 0000; EQUALS comparison

DE Class Year = 2007

Search Legal Name*

Select to include legal names in searches.

Search Middle Name =???Yes???

Buttons

When you click the OK button, the criteria values you entered are displayed in the Additional Criteria group box on the Name Search window and are used when you click the Search button. Also, the Add button on the Name Search window is changed to a Change button when one or more additional criteria are specified.

The Cancel button closes the window and does not save any additional criteria values you may have entered.

*Option only available to users with permission to access legal name information.