Padding to 'linesize' in SQL ?

From: Maurice De Vidts NE3S <ceham_at_w3eax.umd.edu>
Date: 1997/04/04
Message-ID: <5i1p3b$hpl@dailyplanet.wam.umd.edu>#1/1

Hi,

I am trying to build an export ascii file using 'spool' and selecting from a varchar(2000) column. What I would like to have is one record per line, with a linefeed at the end of each record.

Since my columns are rather wide, I set linesize to 2000, and wrap OFF. on output I do get my record in a single line, but it is padded up to 2000 characters with blank spaces. Is there a way to avoid this ?

i.i I would like a linefeed at the end of the string, regardless of the length.

Thanks

Maurice De Vidts
ceham_at_w3eax.umd.edu Received on Fri Apr 04 1997 - 00:00:00 CST