something like this... may be you need to modify it accordingly..

DECLARE @SomeData TABLE

(

FirstName varchar(25)

, MiddleName varchar(25)

, LastName varchar(25)

, StreetAddress varchar(25)

, Suite varchar(25)

, City varchar(25)

, [State] varchar(25)

, PostalCode varchar(10)

, AreaCode varchar(5)

, PhoneNumber varchar(8)

)

INSERT INTO @SomeData

SELECT 'Joe','Al','Smith','123 Main Street',NULL,'Dallas', 'North Carolina', '45789', NULL, NULL UNION ALL

SELECT 'Joe','Al','Smith','123 Main Street',NULL,'Dallas', 'North Carolina', '45789', '256', '124-5879' UNION ALL

SELECT 'Sally','Ann','Smith','123 Main Street',NULL,'Dallas', 'North Carolina', '45789', '256', '124-5879' UNION ALL

SELECT 'Steven','David','Smith','123 Main Street',NULL,'Dallas', 'North Carolina', '45789', '256', '124-5879'

;WITH CTE AS

(

SELECT *, ROW_NUMBER() OVER(PARTITION BY FirstName, MiddleName, LastName Order by AreaCode DESC, PhoneNumber DESC) AS Rnum FROM @SomeData

)

--SELECT * FROM CTE

DELETE FROM CTE

--WHERE Rnum = 1

WHERE Rnum <> 1

SELECT * FROM @SomeData

http://sqlsaga.com/sql-server/how-to-remove-duplicates-from-a-table-in-sql-server/[/url]