참고하세요.

WITH
 TBL(TEXT) AS (VALUES
('1A '),
('1B '),
('2A '),
('2B '),
('3A '),
('3B '),
('4A '),
('4B '),
('5A '),
('5B '),
('6A '),
('6B '),
('7A '),
('7B '),
('8A '),
('8B '),
('9A '),
('9B '),
('10A'),
('10B'),
('10C'),
('11A'),
('11B'),
('11C'),
('13 '),
('14 ') )

SELECT  CHAR(DEC(TRANSLATE(TEXT,'','ABCDEFGHIJKLMOPQRSTUVWXYZ '),3,0)) ||
        LTRIM(TRANSLATE(TEXT,'','0123456789 ')) TEMP ,TEXT  
  FROM  TBL
 ORDER  BY  TEMP