Re: Spool file - Triming columns

Matthieu wrote:
> Hello,
>
> I want to make an extraction into a flat file of the folowing table:
>
> ART
> ====
> CO_ART VARCHAR(12)
> LI_ART VARCHAR(50)
> CO_MOD NUMBER(1)
>
> I want the flat file looks like:
>
> 1529#PRODUCT 1#1
> 1254899#PRODUCT 2222#1
> 12#PROD 1235#2
>
> I use set COLSEP '#' for the separator but how can I make my columns trimed.
> By default it looks like:
>
> 1529 #PRODUCT 1 #1
> 1254899 #PRODUCT 2222 #1
> 12 #PROD 1235 #2
>
> Thanks for help.
>
> Matthieu
>
>

select trim(col1)...

-- 

Regards,
Frank van Bortel