Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Rounding up in SQL Server
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
00775316
Message ID:
00775320
Views:
15
This message has been marked as the solution to the initial question of the thread.
Hi Alan,

Just add .0049
Select ROUND(2128.0748 + .0049, 2)
>Hi,
>
>I need to do some rounding to 2 decimal places - but I need to round up and I'm not sure how to get the results I'm looking for.
>
>For example:
>
>
>Select ROUND(2128.0748, 2)
>
>returns 2128.07
>
>
>
>I want it to return 2128.08 - any ideas on how to go about achieving this result?
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform