Take a look at the help for COPY TO - TYPE SDF is probably what you are looking for.
>hi all,
>i have a cursor that i need to copy to/export to an undelimited text file. It has to be integrated into another system and the format does not include any comma's semi-colons etc.
>Slán
>~M
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown