ASP.NET如何按照字母顺序正序或者倒序排列

比如一个数据表
abz
sda
zoa
按照字母顺序 即从左到右 依照字母顺序排列
abz
sdz
zoa
倒序则是
zoa
sdz
abz请问如何做

---

根据他的ASCII码来比较

---

莫非是我理解错了？
SQL里面自带的查询，不就是按首字母来进行排序的？
我OUT了？

一下sdz,一下sda？会变？

---

你再说明白点不？  排列是转换成ASCII码比较的。

---

按字母排列A-E
select * from wy_Down_Spec where SpecName between 'a' and 'e' or SpecName between '阿' and '鞥' order by SpecName collate Chinese_PRC_CS_AS_KS_WS

按字母排列F-K
select * from wy_Down_Spec where SpecName between 'f' and 'k' or SpecName between '发' and '困' order by SpecName collate Chinese_PRC_CS_AS_KS_WS

按字母排列L-N
select * from wy_Down_Spec where SpecName between 'l' and 'n' or SpecName between '拉' and '黁' order by SpecName collate Chinese_PRC_CS_AS_KS_WS

按字母排列O-T
select * from wy_Down_Spec where SpecName between 'o' and 't' or SpecName between '哦' and '臋' order by SpecName collate Chinese_PRC_CS_AS_KS_WS

按字母排列U-Z
select * from wy_Down_Spec where SpecName between 'u' and 'z' or SpecName between '哇' and '繜' order by SpecName collate Chinese_PRC_CS_AS_KS