>alltrim(transform(value), 1, '0') && this will remove trailing zeros but will make this character valueWhoops! Your solution trims significant zeroes as well in say, 890 becomes 89.
? IIF(AT('.', TRANSFORM(cc)) > 0, alltrim(transform(cc), 1, '0'), TRANSFORM(cc))