Hi,

I need (customer actually) to store data from a cursor into a text file delimited with tab. When use command COPY as

SELECT MYCURSOR
COPY TO MyText.TXT DELIMITED WITH TAB

the content of MyText.txt shows each value in quotation marks. My understanding is that the customer wants the data to be in columns of certain length (for each column) and then tab between each column. For example, here is how I think he wants the data:

3934447      04/06/2012    100.00       M34444       This is description of item              ABCD            33333
                                                                                 from memo field

Note that all column above (except the one showing date and 100.00 are coming from Character fields. How can I output/store a cursor in the above-type format?

I would appreciate any suggestions.