SQL 질문드립니다. 데이터의 형식을 바꾸고 싶습니다.

WITH TEST_TABLE

     AS (SELECT '25T' AS CAR_TON FROM DUAL UNION ALL

         SELECT '25T' AS CAR_TON FROM DUAL UNION ALL

         SELECT '14T' AS CAR_TON FROM DUAL UNION ALL

         SELECT '25T' AS CAR_TON FROM DUAL UNION ALL

         SELECT '14T' AS CAR_TON FROM DUAL UNION ALL

         SELECT '25T' AS CAR_TON FROM DUAL UNION ALL

         SELECT '25T' AS CAR_TON FROM DUAL UNION ALL

         SELECT '14T' AS CAR_TON FROM DUAL UNION ALL

         SELECT '14T' AS CAR_TON FROM DUAL UNION ALL

         SELECT '5T' AS CAR_TON FROM DUAL UNION ALL

         SELECT '25T' AS CAR_TON FROM DUAL UNION ALL

         SELECT '5T' AS CAR_TON FROM DUAL UNION ALL

         SELECT '14T' AS CAR_TON FROM DUAL UNION ALL

         SELECT '14T' AS CAR_TON FROM DUAL UNION ALL

         SELECT '5T' AS CAR_TON FROM DUAL UNION ALL

         SELECT '5T' AS CAR_TON FROM DUAL UNION ALL

         SELECT '25T' AS CAR_TON FROM DUAL UNION ALL

         SELECT '5T' AS CAR_TON FROM DUAL UNION ALL

         SELECT '25T' AS CAR_TON FROM DUAL UNION ALL

         SELECT '14T' AS CAR_TON FROM DUAL UNION ALL

         SELECT '25T' AS CAR_TON FROM DUAL UNION ALL

         SELECT '25T' AS CAR_TON FROM DUAL)

SELECT CASE

          WHEN LENGTHB (CAR_TON) > 2

          THEN 'T' || replace(car_ton, 'T', '') * 100

          ELSE 'T0' || replace(car_ton, 'T', '') * 100

       END AS CAR_TON

  FROM TEST_TABLE;