>>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
>
>If this is a VFP table then you will get "SQL: GROUP BY clause is missing or invalid' with ENGINEBEHAVIOR = 90
>
>With ENGINEBEHAVIOR 70 you would get a unique list of locations but the values for the other fields are unpredictable (I'm pretty sure they come from the last physical record in the table for each location - but I'm not 100% on that and, anyway, that's not something you really want to bank on).
>
>If you provide a table structure and some sample records and the desired result, I'm sure that you'll get several responses on how to get what you need.


Thank you.