字段排序的问题？
ab字段为字符型
10 plat
100Plat
20 plat
30 plat
50 plat
怎么才能让他这样排序
10 plat
20 plat
30 plat
50 plat
100plat
[解决办法]
顶
[解决办法]
关注！
[解决办法]
把前面的数字转换成int，再排序
[解决办法]
string[] oldStr = new string[] { "10 plat ", "100Plat ", "20 Plat " };
int[] temp = new int[oldStr.Length];
for (int i = 0; i < oldStr.Length; i++)
{
temp[i] =Convert.ToInt32( oldStr[i].Substring(0, 3).Trim());
}
[解决办法]
SELECT CONVERT(int, REPLACE(aaaa, 'plat ', ' ')) AS bbb
FROM test
ORDER BY bbb DESC
