Re: CHAR manipulation

From: <dmausner_at_brauntech.com>
Date: Mon, 9 May 1994 04:25:02 GMT
Message-ID: <1994May9.022452.19452_at_nntpxfer.psi.com>


In article <1994May6.225354.16003_at_rzu-news.unizh.ch>, <steiger_at_geo.umnw.ethz.ch> writes:
> SQL> select * from sensor;
>
> SRKEY SRETHNR SROBJNR
> ---------- ---------- ------------
> 56 1473 1473
> 58 1067 1067 -->| move to the right!
> I'd like to eliminate all spaces right of SROBJNR, so that the result looks
> like the first line (SRKEY = 56).

update sensor set srobjnr = lpad(rtrim(ltrim(srobjnr)),12);

--
dave mausner, sr consultant _at_ braun technology group, chicago
Received on Mon May 09 1994 - 06:25:02 CEST

Original text of this message