>I want to remove duplicate VFP Memo records using SQL.
>
>Any ideas on how this is accomplished?
>
>*Can the code below be modified to remove duplicates in a memo field?
>
>USE URLS
>* Using SQL to remove dupicates (Thanks Naomi)
>SET ENGINEBEHAVIOR 90
>SELECT * FROM URLS GROUP BY Location INTO TABLE URLtemp
>SET SAFETY OFF
>CLOSE TABLES ALL
>COPY FILE URLtemp.DBF TO URLS.DBF
>CLOSE TABLES ALL
Is Location the memo?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.