Re: to_char(123, '999999') problem

Mike Morgan wrote:
>
> 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
> >

Or use the FM format mask.

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse