ROUND Function

[2J]

Does anyone know how SQL Server chooses to round when the last digit after the decimal point is 5. I've used this function in a stored procedure and two records with the same value (0.265) get returned differently, 0.26 and 0.27. At this point my only solution is to do the rounding in Crystal Reports and not from SQL Server directly. I would love to know why this happens and if there is a another solution.<br>
<br>
<br>
Thanks<br>
2J

 

[2J]

I found the solution to the problem on another forum.<br>
<br>
<br>
Using the decimal datatype instead of float fixes the problem because float only aproximates values. For complex mathematical calculations decimal, money and numeric datatypes are mre appropriate