Re: CHAR manipulation
From: Dale Cooper <cooper_at_seismo.CSS.GOV>
Date: 12 May 1994 14:00:11 GMT
Message-ID: <2qtcpb$qgl_at_seismo.CSS.GOV>
>
>update sensor set srobjnr = lpad(rtrim(ltrim(srobjnr)),12);
>--
>dave mausner, sr consultant _at_ braun technology group, chicago
Date: 12 May 1994 14:00:11 GMT
Message-ID: <2qtcpb$qgl_at_seismo.CSS.GOV>
In article <1994May9.022452.19452_at_nntpxfer.psi.com> dmausner_at_brauntech.com writes:
>
>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
Ouch! I dunno if updating the table is such a swell idea. It sounds as though all that was requested was the ability to display the column in the same format at the SRETHNR column. Try:
select SRKEY,SRETHNR,to_number(SROBJNR) SROBJNR from sensor;
That should do it just fine...
Dale Cooper
Center for Seismic Studies
Arlington, VA
Received on Thu May 12 1994 - 16:00:11 CEST