Help with Decimal Roundings

[vuyiswamb]

hi Guys , i am a bit stuck here

i have this value "0.833333333333333"

and i want the asnwer to be 83 , i tried this

SELECT ROUND(0.833333333333333,2)

but it does not work

[BruceG]

try:

SELECT ROUND(0.833333333333333 * 100,0)

[TysonLPrice]

This will bring back "83".

select convert(decimal(12,0),ROUND(0.833333333333333 * 100,0))

[techgnome]

"but it does not work" -- I beg to differ... it does work... it's doing exactly what you told it to do... round to two decimal places (.83). just so happens that the result isn't what you want... (83)
There's two solutions... 1) multiply it by 100 then round to 0 decimal places...as the previous posters did.... or, round to 2 decimal places THEN multiply by 100.

-tg