Re: Number problem

Thanks to everyone who replied - quite a few different methods - and yes - sorry I did mean round up to the next 5000 not nearest. Anyhow - I think I was trying to overcomplicate so do I win the prize as the most complex solution? ;-)

Cheers

Steve

Vinod Gopinath BMMI IS wrote:

>Or does this gives you any idea..
>
>SQL> select round(96130045, -4) from dual;
>
>ROUND(96130045,-4)
>------------------
> 96130000
>
>SQL> select round(96136462, -4) from dual;
>
>ROUND(96136462,-4)
>------------------
> 96140000
>
>-----Original Message-----
>From: oracle-l-bounce_at_freelists.org
>[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Steve Jelfs
>Sent: Thursday, December 23, 2004 3:38 PM
>To: Oracle-L Freelists
>Subject: Number problem
>
>
>Within Oracle, how can I round up an 8 figure number to the nearest 5000
>
>such that 96136462 becomes 9614000 and 96130045 becomes 96135000?
>Maths was never my strong point!!! ;-)
>
>Steve
>
>
>

--
http://www.freelists.org/webpage/oracle-l