Re: zero filling a number

"Troy & Michelle Dodsworth" <troydods_at_storm.ca> wrote in message news:bl5epj$pc4$1_at_news.storm.ca...
> Why does select to_number(' 123',000999) from dual
>
> return 123 rather than the expected 000123 ? since the is the suppose to
 be
> the purpose of the pattern ?
>
> Troy.
>
>

Troy

Shouldn't your SQL be :

select to_char(123,'000999') from dual

eric

--
Remove the dross to contact me directly