select * from table
order by left(sort_column,patindex('%[0-9]%',sort_column)-1),
cast((substring(sort_column,cast((patindex('%[0-9]%',sort_column)) as int),100)) as int)
SQL SERVER 截取NVARCHAR字段按数字排序
最新推荐文章于 2021-07-10 11:45:32 发布
select * from table
order by left(sort_column,patindex('%[0-9]%',sort_column)-1),
cast((substring(sort_column,cast((patindex('%[0-9]%',sort_column)) as int),100)) as int)