/*这个可以排序中文和数字加字母组合!*/
select [字段] from [表名] order by LEN([字段]), [字段]
/*这个可以排序中文数字!(列中只有中文数字)*/
select [字段] from [表名] order by charindex([字段],'一二三四五六七八九十')
/*这个可以排序中文数字!(列中包含中文数字)*/
select [字段] from [表名] order by
charindex('一',[字段]) desc,
charindex('二',[字段]) desc ,
charindex('三',[字段]) desc ,
charindex('四',[字段]) desc ,
charindex('五',[字段]) desc,
charindex('六',[字段]) desc ,
charindex('七',[字段]) desc ,
charindex('八',[字段]) desc,
charindex('九',[字段]) desc ,
charindex('十',[字段]) desc