Remove white space in spool data file

I would like to remove the white space in a spool file.

I am able to do this by doing the RTRIM(LTRIM(COLx)), but is there an easy way to do this by using a SET command instead of wrapping the rtrim & ltrim around each an every column?

Change from the current: XXXXX | 111| 0|01/29/2002|ABCD To: XXXXX|111|0|01/29/2002|ABCD

TIA I am using Oracle 8.1.7

Simon Received on Wed Feb 27 2002 - 09:17:18 CST