create function dbo.FN_SPLIT_STRING
(
@INPUT_STRING varchar(max),
@DELIMITER varchar(100)
)
returns @result table
(
STRING_VALUE varchar(1000)
)
AS
BEGIN
declare @i int
while(CHARINDEX(@DELIMITER, @INPUT_STRING)>0)
begin
set @i = CHARINDEX(@DELIMITER, @INPUT_STRING)
insert into @result values(LEFT(@INPUT_STRING,@i-1))
set @INPUT_STRING = RIGHT(@INPUT_STRING,len(@INPUT_STRING)-@i)
end
insert into @result values(@INPUT_STRING)
return
END