Hi, I found different round result at below mysql> select round(1.235,2); +----------------+ | round(1.235,2) | +----------------+ | 1.24 | +----------------+ 1 row in set (0.00 sec)
mysql> select round(1.325,2); +----------------+ | round(1.325,2) | +----------------+ | 1.32 | +----------------+ 1 row in set (0.00 sec) What does it mean?? I wonder that round must increase the front value 1 step, but the second command show the wrong value. Please help me correct round function or any idea to fixed with coding. SF --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php