How do I put a carraige return and a line feed at the end of a line that is generating a text file? The problem is when I move the text file from a Unix box to an NT box, the text file loses the carraige return and line feed. I know the @CHR(10) and @CHR(13) are the characters, but am not sure how to use them.

Thanks,

Found out how to do it, just add CHAR(10) + CHAR(13) at the end of the line.