I'd stage into a temporary table with an identity column and delete from the temp table where

1. The phone number or area code are null

2. And the name and address columns exist elsewhere with a different identity than the current row.

Did I capture the conditions correctly?

Thanks

John.