SELECT alltrim(field1) from table1 into cursor mytemp
COPY to myfile.sdf type sdf
>The contents of expression ALLTRIM(field1) is "info 01 ABCD". If I send this expression to a text file by the code: SELECT ALLTRIM (field1) FROM table1 TO FILE myfile PLAIN, it places "info 01 ABCD" into the text file but with unwanted spaces before and after. What I need is the exact expression "info 01 ABCD", a carriage return and no empty spaces after. For example if I send four ALLTRIM(field1)’s to the text file one after the other it will be formatted as
>
>info 01 ABCD
>info 01 ABCD
>info 01 ABCD
>info 01 ABCD
>
>Is this possible? Can I control formatting in a text file to that extent?
--Todd Sherman
-Wake Up! Smell the Coffee!