Re: to_char(123, '999999') problem

You can insert the FM element in the the format string.

e.g. to_char(123, 'FM999999')

this returns a value without leading or trailing blanks.

Martin

Marcos Leija wrote:
>
> 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