Allan,

You can use fixed length records, but in this format there is no delimiter at all (there is no need for it).

COPY TO text1.txt TYPE SDF

>Is there any way to have a 'copy to text file' retain trailing spaces?
>
>For example, assuming that there is one character field in the source file and that the field contains all spaces (as opposed to null), the result in the output text file is "" (literally).
>
>Is there any way to force the spaces to be within the quotes?
>
>TIA.