急！！请教如果排序

[会飞的小洋洋]

varchar(100)的一个数据列，含数据'B01-09-03','10003-02-01','1-1-3','A02-02-01','A02-02-02','1-1-4'

得到一个顺序结果
'1-1-3'
'1-1-4'
'10003-02-01'
'A02-02-01'
'A02-02-02'
'B01-09-03'

[gahade]

CREATE function udf_splitstring
(
@str varchar(8000) --要分拆的字符串
,@spli varchar(10) --字符串分隔符
)
returns @retab table(istr varchar(8000))
as
begin
declare @i int
declare @splen int
select @splen=len(@spli),@i=charindex(@spli,@str)
while @i > 0
begin
insert into @retab
values(left(@str,@i-1))
select @str=substring(@str,@i+@splen,8000)
select @i=charindex(@spli,@str)
end
if @str<>'' insert into @retab values(@str)
return
end
GO

select istr
from udf_splitstring('''B01-09-03'',''10003-02-01'',''1-1-3'',''A02-02-01'',''A02-02-02'',''1-1-4''',',')
order by left(istr,charindex('-',istr)-1)

[gahade]

--结果
/*
istr
--------------
'1-1-3'
'1-1-4'
'10003-02-01'
'A02-02-01'
'A02-02-02'
'B01-09-03'

（所影响的行数为 6 行）

*/

[chuifengde]

set nocount on
declare @a table(a varchar(100))
insert @a select 'B01-09-03'
insert @a select '10003-02-01'
insert @a select'1-1-3'
insert @a select'A02-02-01'
insert @a select'A02-02-02'
insert @a select'1-1-4'

select * from @a order by case when isnumeric(left(a,1)) =1 then charindex('-',a) else 20 end,a

[---涛声依旧---]

樓上正解

[会飞的小洋洋]

To:chuifengde(树上的鸟儿) 厉害

[会飞的小洋洋]

这个是什么原理？太简单了吧。会不会有不满足的？

[肥胖的柠檬]

order by 后机可以加 case,查询,函数的

[lwl0606]

强，学习一下