mysql view manipulation

Change the following mysql view with the changes requested. I already have it format the view to show 2 places after the decimal. ( select `i1`.`item` AS `item`, `i1`.`description` AS `description`, format(`i2`.`price`,2) AS `100` from (`initm` `i1` join `inprlitm` `i2`) where ((`i1`.`item` = `i2`.`item`) and (`i2`.`descrptn` = '100'))) If [login to view URL] is 0.01 or 0.02 replace with empty (null) so they do not show if [login to view URL] has a 0 before the decimal remove the 0 example is 0.89 should be .89 also on this if the price is 10.00, 100.00, ect.... leave the zeros