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@xxxxxxxxxxxxx
>[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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

Other related posts: