What about

SELECT * FROM mytable ;
  ORDER BY field1, field2 ;
  INTO CURSOR tempfl NOFILTER
SELECT mytable
ZAP 
APPEND FROM ( DBF("tempfl") )

>Dilemma! I’m using VFP7. I have a table as associated to a DBC with several column names longer than 10 characters. When I do a
>
>Sort on field1, field2 to tempfl
>Zap
>Append from tempfl
>
>The field names get truncated to 10 characters and when you append back you lose the data.
>How can I eliminate this issue?
>What is an alternative way of doing this?