@dhromed said:The definition of 'duplicate' is not constant, but can change from system to system. [code]<font face="Courier New">SELECT DISTINCT * INTO tmp FROM Contact;</font>[/code] could delete data. Or leave data the database considers unique but the business layer considers duplicate (same data but different key). Hence the something like.