27,579
社区成员
发帖
与我相关
我的任务
分享
select * from tablename order by PATINDEX('%[A-F]%',right(id,2)),id
SELECT
*
FROM tablename
ORDER BY SIGN(CHARINDEX(RIGHT(Col1,1),'ABCDEF')) ASC,Col1
select * from tablename order by PATINDEX('%[A-F]%,'right(id,2)),id
[/quote] select * from tablename order by PATINDEX('%[A-F]%'right(id,2)),id
SELECT
*
FROM #
ORDER BY PATINDEX('%[A-F]%',RIGHT(id,LEN(id) - 1)),id
或
SELECT
*
FROM #
ORDER BY ISNUMERIC(RIGHT(id,LEN(id) - 1)) DESC,id
SELECT
*
FROM tablename
ORDER BY PATINDEX('%[A-F]%',Col1),Col1