>The APPEND FROM should be faster because it's specificly designed to add records to a table. It wouldn't even occur to me to look for anything else as long as APPEND FROM does it job.
>
>>Which is faster:
>>
>>SELECT ThisTable
>>APPEND FROM ThisTable
>>
>>
>>or
>>
>>
>>SELECT ThisTable
>>SCAN
>> scatter memvar
>> insert into mytable from memvar
>>ENDSCAN
Thanks men.
Work as if you don't need money
Love as if you've never been hurt before
Live as if this is your last day to live
Dance as if no one's watching