Re: [sqr-users] rounding to thousand

["Larry Roux" <LRoux@syr.edu>]

You could always use round by multiplying as such

SELECT
Round(3333 * .001) * 1000
FROM dual

ie: 
3333 * .001 =3.333
3.333 rounded is 3 
3 * 1000 = 3000 



Larry Roux
Syracuse University
lroux@syr.edu


>>> radhika_05@hotmail.com 01/31/06 11:05 AM >>>
Hi,

  I have to round a number to thousands like the following:

Number          Result
6590.78         7000.00
5343.00         5000.00
3000.00         3000.00

I am not able to achieve this through Round function. Can you tell me is 
there any function or how to achieve this.

Thanks,
Radhika

_________________________________________________________________
FREE pop-up blocking with the new MSN Toolbar * get it now! 
http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/ 


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org 
http://www.sqrug.org/mailman/listinfo/sqr-users


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users