Am using SQL Server 2000/T-SQL & trying to create an output text file that must be concatenated into 1 long string. I have a regular table of many rows with the properly formatted data, now I have to figure out how to get it onto the user's desktop in 1 continous string (txt file) so
the user can upload it to a website for processing.

This crazy file format is for the healthcare industry & is the ANSI X12 standard if anyone knows anything about that; all the record segments are separated by tildes(~)...

I've been reading about the text datatype & thought that might help, but I cant seem to figure out how to put all the pieces together.

Any input would be greatly appreciated!!