ALTER
function
[
dbo
]
.
[
Fun_Split
]
(
@c
varchar
(
2000
),
@split
varchar
(
2
))
returns @t table (col varchar ( 20 ))
as
begin
while ( charindex ( @split , @c ) <> 0 )
begin
insert @t (col) values ( substring ( @c , 1 , charindex ( @split , @c ) - 1 ))
set @c = stuff ( @c , 1 , charindex ( @split , @c ), ' ' )
end
insert @t (col) values ( @c )
return
end
returns @t table (col varchar ( 20 ))
as
begin
while ( charindex ( @split , @c ) <> 0 )
begin
insert @t (col) values ( substring ( @c , 1 , charindex ( @split , @c ) - 1 ))
set @c = stuff ( @c , 1 , charindex ( @split , @c ), ' ' )
end
insert @t (col) values ( @c )
return
end