>>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
I ain't skeert of nuttin eh?
Yikes! What was that?