InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 09:16:12 GMT20http://www.sqlservercentral.com/Forums/Topic1383990-392-1.aspx[code="sql"]SELECT CEILING(10.434 * 100)/100[/code]Tue, 13 Nov 2012 03:20:05 GMTEugene Elutinhttp://www.sqlservercentral.com/Forums/Topic1383990-392-1.aspxYour rounding is not following correct rounding rules, typically anything between 0-4 is rounded down and 5-9 rounded up, so to round a value to 10.44 it would have to be between 10.435 and 10.444.Can you explain why your logic is not to follow standard rounding?Tue, 13 Nov 2012 02:48:50 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1383990-392-1.aspxIm performing some calculations and I need to round up the 2 decimal places to the next highest placeegcalculation result 10.434 should become 10.44I cant seem to do this with the ROUND function, is the anything else that will do this ?Tue, 13 Nov 2012 02:39:19 GMTsolus