27,580
社区成员
发帖
与我相关
我的任务
分享
DECLARE @TB TABLE([COL] VARCHAR(10))
INSERT @TB
SELECT '000017' UNION ALL
SELECT '042834' UNION ALL
SELECT '046848' UNION ALL
SELECT '086411' UNION ALL
SELECT '1010100001' UNION ALL
SELECT '1010100002' UNION ALL
SELECT '1010100004' UNION ALL
SELECT '1010100006'
SELECT * FROM @TB ORDER BY LEN(COL) DESC,COL
/*
COL
----------
1010100001
1010100002
1010100004
1010100006
000017
042834
046848
086411
*/