>>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?

No it is not, but I have solved the problem. Thank you Borislav