Re: CHAR TO NUMBER - NUMBER TO CHAR

From: Lawrence Simela <lsimela_at_mahalini.prestel.co.uk>
Date: Fri, 28 Sep 2001 16:20:56 +0100
Message-ID: <9p2454$g31$2@phys-ma.sol.co.uk>

select lpad(to_number('0004')+1, 4, '0') from dual

hth
Lawrence

"Félix" <fgaitero_at_e-netfinger.com> wrote in message news:9p1ela$nsl$1_at_talia.mad.ttd.net...
> I have to converse a datatype from CHAR(4): '0004', to NUMBER: 4. Then I
> add 1 to this number: 4 + 1 = 5. I converse it to CHAR again but, when I
> select this value from the table I just get 5 and not 0005 as I want. It's
> still a CHAR(4) but it appears only with one character and not four as it
> should.
> How could I do to obtain '0005' and not '5' ?
> Thanks.
> Félix
>
>
Received on Fri Sep 28 2001 - 10:20:56 CDT