Re: [GENERAL] Attribute 'rtrim' is repeated

2003-10-31 Thread Stephan Szabo
On Tue, 28 Oct 2003 [EMAIL PROTECTED] wrote: > > In trying to trim some data while selecting and loading from 2 tables > into 1 I get the following: > > SELECT TRIM(TRAILING ' ' FROM s.strk_sym_cmplt), TRIM(TRAILING ' ' FROM > s.stk_sym), s.c_p, o.dta_date, o.dta_date_num, o.dta_date_dys, o.strk_s

[GENERAL] Attribute 'rtrim' is repeated

2003-10-31 Thread Lynn . Tilby
In trying to trim some data while selecting and loading from 2 tables into 1 I get the following: SELECT TRIM(TRAILING ' ' FROM s.strk_sym_cmplt), TRIM(TRAILING ' ' FROM s.stk_sym), s.c_p, o.dta_date, o.dta_date_num, o.dta_date_dys, o.strk_sym, o.strk_yr, s.strk_num, s.exp_sym, s.exp_mo, s.exp_mo