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