How are you checking your duplicate criteria ?

Currently we’re using the match key below:

UPPER(SUBSTRING(Name.ZIP,1,5) + (CASE WHEN Name.LAST_NAME<>” THEN (SUBSTRING(Name.LAST_NAME,1,4) + SUBSTRING(Name.FIRST_NAME,1,1)) ELSE SUBSTRING(Name.COMPANY,1,5) END))

I’m not sure to understand. That doesn’t check for duplicates at all.
I would expect something in your report’s query.

ok, I viewed the stored procedure it’s calling and it’s below:

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER PROCEDURE [dbo]. AS
BEGIN
SELECT N.ID, N.LAST_NAME, N.FIRST_NAME, NA.ADDRESS_1, NA.ADDRESS_2, NA.CITY, NA.STATE_PROVINCE,
NA.ZIP, NA.COUNTRY, N.MEMBER_TYPE
FROM NAME N, NAME_ADDRESS NA, ( SELECT LAST_NAME, STATE_PROVINCE, COUNTRY, COUNT(1) COUNT1
FROM NAME
WHERE LAST_NAME <> ” AND STATE_PROVINCE <> ”
GROUP BY LAST_NAME, STATE_PROVINCE, COUNTRY
HAVING COUNT(1) > 1) T
WHERE T.LAST_NAME = N.LAST_NAME
AND T.STATE_PROVINCE = NA.STATE_PROVINCE
AND T.STATE_PROVINCE = N.STATE_PROVINCE
AND T.COUNTRY = NA.COUNTRY
AND N.ID = NA.ID
AND N.MAIL_ADDRESS_NUM = NA.ADDRESS_NUM
– AND T.LAST_NAME = ‘HARRISON’
ORDER BY N.LAST_NAME, N.STATE_PROVINCE, N.COUNTRY
END