Help with Decimal Roundings-VBForums

# Thread: Help with Decimal Roundings

1. ## Help with Decimal Roundings

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

Code:
`SELECT ROUND(0.833333333333333,2)`
but it does not work

2. ## Re: Help with Decimal Roundings

try:
Code:
`SELECT ROUND(0.833333333333333 * 100,0)`

3. ## Re: Help with Decimal Roundings

This will bring back "83".

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

4. ## Re: Help with Decimal Roundings

"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

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•