How To Get Rid Of The Last 2 0's?

1.	How To Get Rid Of The Last 2 0's?
Answer» SELECT CAST(4.12345700E+3 AS CHAR) FROM DUAL; 4123.457 SELECT CAST(1/3 AS CHAR); 0.3333 SELECT CAST(4.12345700E+3 AS CHAR) FROM DUAL; 4123.457 SELECT CAST(1/3 AS CHAR); 0.3333

Answer»

SELECT CAST(4.12345700E+3 AS CHAR) FROM DUAL;
4123.457
SELECT CAST(1/3 AS CHAR);
0.3333

Discussion