Number of Characters to Compare

This column indicates the number of characters to compare for the column beginning with the first character in a string.

This column is only available if one of the following TABLE.COLUMN rows is selected in the Columns to Compare column:

NAME_MASTER.FIRST_NAME

NAME_MASTER.LAST_NAME

NAME_MASTER.MIDDLE_NAME

NAME_MASTER.PREFERRED_NAME

NAME_MASTER.BIRTH_NAME

NAME_MASTER.NICKNAME

ALTERNATECONTACTMETOD.ALTERNATECONTACTMETHOD

ADDRESS_MASTER.ADDR_LINE_1

ADDRESS_MASTER.ADDR_LINE_2

ADDRESS_MASTER.ADDR_LINE_3

ADDRESS_MASTER.CITY

ADDRESS_MASTER.ZIP

You must enter a number greater than 0 and equal to/less than the database column length.

·       If you enter a number equal to/less than 0, the following message is displayed: "Please enter a value in the # of Chars to Compare that is >0 for the <Field to Compare COLUMN>." The cursor is positioned in the appropriate row for you to correct.

·       If you enter a number greater than the database column length, the following message is displayed: "Please enter a value in # of Chars to Compare that is less than or equal to the DB column width of <width of column> for the <Field to Compare COLUMN>." The cursor is positioned in the appropriate row for you to correct.

You are not allowed to enter a value in this column (Number of Characters to Compare) for the following columns. The maximum number of characters for the selected column (using the specified table and column name) defaults in.

PHONE_MASTER.MOBILE_PHONE

NAME_MASTER.PREFIX

NAME_MASTER.SUFFIX

BIOGRAPH_MASTER.SSN

BIOGRAPH_MASTER.BIRTH_DTE

ADDRESS_MASTER.STATE

PHONE_MASTER.PHONE