>I know there was a thread here recently that discussed finding duplicates using SQL... but the UT search seems to be broken, so I'll ask if anyone can provide the thread # or sample code.

SET SHAMELESS_PLUG ON

If you're running Visual FoxPro 5.0a, there's a file called DupCheck() in the UT's Files section that gives you a hand interface to the problem, as well as documentation on how it was constructed.

If you're running VFP 6.0, be patient - I'm updating it now...

SET SHAMELESS_PLUG OFF ;)