mysql>mysql> SELECT TRUNCATE(10.28*100,0);+-----------------------+| TRUNCATE(10.28*100,0) |+-----------------------+| 1028 |+-----------------------+1 row in set (0.00 sec)mysql>