Jos,
Textmerge would be fast but I think still Copy to is the fastest method. You could use Copy to along with "Set fields to". Here is a sample:

Re: Side by side comparison (strings & local data) Thread #861648 Message #865385

Cetin

>I need to add extra formatting text between fields and dependent on field contents. So simple COPY will not work. Do you think using SET TEXTMERGE TO VARIABLE will be faster?
>
>Thanks,
>
>>What about

>>COPY TO ... TYPE DELIMITED WITH TAB
>>

>>?
>>
>>>
>>>I need to build a string of tab delimited fields from a table. I have been using something similar to:
>>>
>>>

>>>cMyString = ""
>>>
>>>SCAN 
>>>
>>>  cMyString = m.cMyString + myTable.Field1 + CHR(9) + myTable.Field2 + CHR(9) + CHR(13)
>>>
>>>ENDSCAN
>>>

>>>
>>>Is there a faster way such as, for example, using TEXTMERGE?
>>>
>>>TIA