Re: to_char(123, '999999') problem

[Quoted] When a number is converted to text, a leading space is left in case the number is negative (eg: to_char(-123,'99999')). If you don't want a leading space, you'll have to ltrim(to_char(123, '999999')).

Mike

Marcos Leija <marcos.leija_at_cas-mddc.com> wrote in message news:390E051A.6CF86E98_at_cas-mddc.com...
> How do I get rid of the leading space that to_char() creates when I set
> it up like this:
> to_char(123, '999999')
> returns ' 123'
>
>
> In actuality, I need to_char() to do this:
> to_char(123, '099999')
> ...but it does the same thing.
>
> Is this a bug or is this some setting I left out?
> Marcos
>
Received on Tue May 02 2000 - 00:00:00 CEST