排序有关问题，求帮助~

排序问题，求帮助~~~~
表中一列数据为：7,2,a,e,8,1,c等，为数据和字母混合，
先根据数字顺序排序，再根据字母顺序排序，得到结果：1,2,7,8,a,c,e


[解决办法]
select * from tb order by uncode(字段)
[解决办法]

SQL code

CREATE TABLE #T1(    col varchar(10) not null)insert into #T1Select '1' union Select '4' union Select 'a' union Select 'c' union Select '7' union Select '2' union Select 't' union Select 'b' Select * From #T1 order by col
[解决办法]
SQL code
IF EXISTS (SELECT 1 FROM SYSOBJECTS WHERE name = 'tba')BEGIN    DROP TABLE tbaENDGOCREATE TABLE tba(    memo VARCHAR(100))GOINSERT INTO tbaSELECT '7' UNIONSELECT '21' UNIONSELECT 'a' UNIONSELECT 'e' UNIONSELECT '8' UNIONSELECT '1' UNIONSELECT 'c'GOSELECT memoFROM tbaORDER BY CASE WHEN ISNUMERIC(Memo) > 0 THEN CAST(memo AS INT)              ELSE 2147483647 END memo17821ace