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)