0

So i'm using 'ToEven' rounding in C sharp code, and its in many places, so do not want to alter that, its ok

However, in SQL Server, i need it to work 100% same all of the time, proving very difficult

PROMBLEM: I need a version of Round() function in SQL Server that will round these 2 values to specific 2 decimal place amounts, i.e.

3 STATES TO BE SATISFIED...

81.735 needs to round to 81.73 (if 3rd digit after "." 5 then leave as it is)

133.3183 needs to round to 133.32 (i.e. round up since 3rd digit > 5)

133.3143 needs to round to 133.31 (since 3rd digit is < 5)

John
  • 1,407
  • 3
  • 20
  • 43

0 Answers0