mysql> select 1+1.0; +-------+
| 1+1.0 | +-------+ | 2.0 | +-------+ 1 row in set (0.00 sec) mysql> select 1+1.1; +-------+ | 1+1.1 | +-------+ | 2.1 | +-------+ 1 row in set (0.00 sec) Is there a way to tell MySql to only return '2' in the first select as opposed to '2.0'? The second select is correct and should remain as such. Basically I have two columns, one with an integer and another with a decimal. And I'm adding the two, but for those where the decimal has a .0, I just want the result to not have the .0 and for those that do have anything other than .0, to display it accordingly. mysql> select version(); +------------+ | version() | +------------+ | 5.1.47-log | +------------+