CREATE FUNCTION [DA].[fn_Split]
(
@String nvarchar(max), 
@Delimiter nvarchar(1)
) 
RETURNS @TempTable TABLE (whichitem int identity, items nvarchar(max), FilePath nvarchar(max)) 
as 
begin 
  
 declare @intPosition int
 ,@vchElement nvarchar(max)
 ,@originalString nvarchar(max)
 set @originalString=@String
 if len(@String) < 1 or @String is null
 return 
 
 set @intPosition = 1
 while @intPosition <> 0 
 begin 
 set @intPosition = charindex(@Delimiter, @String) 
 if @intPosition <> 0 
 set @vchElement = left(@String, @intPosition - 1) 
 else 
 set @vchElement = @String 
 
 if len(@vchElement) > 0
 insert into @TempTable(items) values(@vchElement) 
  update @TempTable set [FilePath]=@originalString
 set @String = right(@String, len(@String) - @intPosition) 
 if len(@String) = 0 break 
 end

 return
end