declare @a varchar(100)
set @a='825hw-03-4/10/12'
set @a=substring(@a,len('825hw-03-')+1,len(@a)-len('825hw-03-'))+'/'
declare @b table
(
idx int identity(1,1),
Val int
)
declare @c int
while len(@a)>0
begin
insert into @b select left(@a,charindex('/',@a)-1)
set @a=substring(@a,len(left(@a,charindex('/',@a)))+1,10)
end
select * from @b
先自定义split函数
--------------------------
Create Function Split(@Sql varchar(8000),@Splits varchar(10))
returns @temp Table (a varchar(100))
As
Begin
Declare @i Int
Set @Sql = RTrim(LTrim(@Sql))
Set @i = CharIndex(@Splits,@Sql)
While @i >= 1
Begin
Insert @temp Values(Left(@Sql,@i-1))
Set @Sql = SubString(@Sql,@i+1,Len(@Sql)-@i)
Set @i = CharIndex(@Splits,@Sql)
End
If @Sql <> ''
Insert @temp Values (@Sql)
Return
End