Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

duplicate records

Status
Not open for further replies.

ohio1954

Technical User
Dec 5, 2007
2
US
How do I find duplicate records in one column of a rather large database??
 
USE SomeTable exclusive
Copy to Backup
Set deleted off
delete all
index on somefield to (index or NDX) UNIQUE
set order to SomeIndex
Recall all
set order to
browse for Deleted() There are all your duplicates.

to get ride of them
Copy to Delrecs for deleted()
pack


David W. Grewe Dave
 
thanks for the help. I really appreciate it.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top