Do you know if there is a way to stop returned data from breaking to the next line? I need one continuous row of data for each record I retrieve. If I use the LINESIZE function, I have to make it large enough so that when I open the spooled file, I do not see a few line breaks for each row of data. Of course, in instances where the file's to large to open, I run multiple queries with a data range (in hopes to make the files small enough to open). I have been searching online for some sort of information. However, I'm wasting time. Is their an easier way to stop the breaking and keep the spooled file size down?