1号楼 2号楼 3号楼,n号楼,怎么按照order by LouHao ASC排序

1号楼 2号楼 3号楼,.............n号楼,如何按照order by LouHao ASC排序？
1号楼 2号楼 3号楼,.............n号楼,如何按照order by LouHao ASC排序？



[解决办法]

SQL code

IF EXISTS (SELECT 1 FROM SYSOBJECTS WHERE name = 'TBC')BEGIN    DROP TABLE TBCENDGOCREATE TABLE TBC(    louhao VARCHAR(100))INSERT INTO TBCSELECT '1号楼' UNIONSELECT '3号楼' UNIONSELECT '2号楼' UNIONSELECT '4号楼' UNIONSELECT '6号楼' UNIONSELECT '5号楼' UNIONSELECT '8号楼' UNIONSELECT '7号楼' UNIONSELECT '9号楼' UNIONSELECT '10号楼' UNIONSELECT '12号楼' UNIONSELECT '11号楼'SELECT louhaoFROM TBCORDER BY CAST(LEFT(louhao,CHARINDEX('号',louhao) - 1)  AS INT)louhao1号楼2号楼3号楼4号楼5号楼6号楼7号楼8号楼9号楼10号楼11号楼12号楼