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