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字段按数字排序
最新推荐文章于 2023-09-04 16:00:16 发布
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)