The integrated round-function works well so far, especially because it does "bankers rounding". Tough it seems to have a little bug, wich is probably simple to fix.
Try... select round(0.94, 1) -> gives 0.9, wich is correct select round(0.96, 1) -> gives 1, wich is correct too but... select round(0.95, 1) -> gives 0, wich is not correct of course Regarding bankers rounding, wich rounds up in case of a '5' at the appropriate position, the correct result should be 1. (tested with 3.3.17) Regards, Olaf Schmidt -- View this message in context: http://www.nabble.com/error-in-round-function--tf3897765.html#a11049528 Sent from the SQLite mailing list archive at Nabble.com. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------