Selecting by Last Name/First Name

A borrower can be found by executing a search of the database using a partial or complete Last Name. Optionally, the user can supply a partial or complete First Name value to further restrict the search. A Last Name value (partial or complete) must always be supplied when doing a name search.

To execute a search using the complete Last Name, enter the name value in the Last Name field of the selection screen, and then click on the Find button.

For example:

To execute a search using a partial Last Name, enter the name value together with a "%" character before and/or after the name string, and then click on the Find button. The system will then search for borrowers whose Last Name matches the partial name as follows:


Example

Action Taken

Cartm%

System will search for any Last Name which begins with "Cartm"

%man

System will search for any Last Name which ends with "man"

%artm%

System will search for any Last Name which contains "artm"

For example:

To execute a name search using the optional First Name criteria, you must first provide a Last Name value as described above. Next, enter the name value (together with a "%" character or characters as desired) in the First Name field, and then click the Find button.

When supplying a partial or complete value for the optional First Name selection criteria, the system will search for any borrower whose Last Name meets the specified criteria AND whose First Name matches the supplied search parameter. For example, the following would attempt to find any borrower whose Last Name began with "Cartm" and whose First Name began with the letter "E" :