fn_split.sql

create function fn_split(@str nvarchar(max),@separator as nvarchar(max))
returns @splits table(segment nvarchar(max))
as
begin
	declare @anchor int=CHARINDEX(@separator,@str),@gram int=len(@separator)
	while @anchor>0 and @gram<=len(@str)
	begin
		insert into @splits values(SUBSTRING(@str, 1, @anchor-1))
		set @str=SUBSTRING(@str,@anchor+@gram,len(@str)-@anchor+@gram+1)
		set @anchor=CHARINDEX(@separator,@str)
	end;
	insert into @splits values(@str)
	return;
end

-- by Zap