ALTER
function
[
dbo
]
.
[
my_split
]
(
@c
varchar
(
4000
),
@split
varchar
(
2
))
returns @t table (id int identity ( 1 , 1 ),col varchar ( 500 ))
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 (id int identity ( 1 , 1 ),col varchar ( 500 ))
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