mysql trimming leading zeros- how to avoid? code example

Example: mysql decimal remove trailing zeros

SELECT TRIM(`column_name`)+0 FROM `table_name`;