How to round numbers to the nearest integer?

[Andel]

For example,

956 should round to 950
985.5 should round to 1000
145 should round to 150
and so on...

How to script this in sql?

I'm trying to use the ROUND function in sql but it doesn't work.

Thanks for your help.

Andel

http://www.iluko.com

 

[mrdenny]

Devide by 10 use the round function, then multiply by 10.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)

 

[vongrunt]

985.5 should round to 1000" doesn't fit... maybe the base for rounding is 50?

------
heisenbug: A bug that disappears or alters its behavior when one attempts to probe or isolate it
schroedinbug: A bug that doesn't appear until someone reads source code and realizes it never should have worked, at which point the program promptly stops working for everybody until fixed.
[ba

 

[Andel]

thanks for your responses.

yes, round to the nearest 50.

i'll try mrdenny's recommendation.

thanks

Andel

http://www.iluko.com