I used these:

SELECT n, RTRIM(n,'0') AS noZeroes, RTRIM(RTRIM(n,'0'),'.') AS noDot
 FROM ( VALUES (123.456700), (123.456), (123) ) AS s (n);