Trimming whitespaces of a column 1

[williey]

I need to try the excess whitespaces of a column when I spool it to a file. Take for an example, a column defined as varchar(50). But the actual data is only 20 chars long. I need to trim the remaining 30 when it is spooled to a file.

Tried rtrim, ltrim, etc but it does not work..

Birth of new OSs is the natural evolution of Unix.

 

[LKBrwnDBA]

You need to "concatenate" the columns:

set trims on lin 132 pages 0 term off ver off feed off
SPO Result.txt
SELECT col1||'|'||col2||'|'|col3
  FROM MyTable;

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[williey]

Thanks! That example now reminds me how we do it at my previous job.

Birth of new OSs is the natural evolution of Unix.