在SQL语句后面加 :
order by
Cast((left(
right(DishesEnname,len(DishesEnname)-patindex('%[0-9]%',DishesEnname)+1)+'a',
patindex('%[a-z,A-Z]%',
right(DishesEnname,len(DishesEnname)-patindex('%[0-9]%',DishesEnname)+1)+'a')
-1)) as int) 子句
.SQL 字符串+数字的字段按数字排序
最新推荐文章于 2022-11-30 09:59:18 发布