Problem Creating Report with SQL using Oracle8i

[Trekkie]

Hi<br><br>I'm creating the flat file report using Oracle.&nbsp;&nbsp;The data displays fine, except there is an empty line at the end of the data (carriage return).&nbsp;&nbsp;How do I eliminate the carriage return or empty line at the end, so that all the lines has data.&nbsp;&nbsp;<br><br>sample code<br><br>set pagesize 0&nbsp;&nbsp;<br>set linesize 350<br>set timing off<br>set time off<br>set feedback off<br>set heading off<br>set echo off<br>set space 0 <br>ttitle off <br>btitle off <br>spool c:\test.txt<br>select column<br>from tables;<br>spool off;<br><br>thanx