Re: to_number Problem

karl wrote:
>
> a format mask ie to_number('1.200',999.999) and we still got 1.2 when we
> require 1.200

If you want to format a number, use TO_CHAR!

SELECT TO_CHAR (1.2, '999.000') FROM DUAL; or, in your case:

SELECT TO_CHAR ('1.200', '999.000') FROM DUAL;

-- 
Sport radio: people listening to people watching people having fun
Mailto:roger.wernersson_at_adra.se
BTW: All opinions are mine, all mine, and nobody's but mine.