CREATE FUNCTION UF_TEXT_SPLIT ( @TEXTNVARCHAR(4000) ,@DELIMETERCHAR(1) ) RETURNS @STRINGS TABLE ( POSITION INT IDENTITY(1,1) PRIMARY KEY, VALUE NVARCHAR(MAX) ) AS BEGIN DECLARE @INDEXINT SET @INDEX = -1 WHILE(LEN(@TEXT)>0) BEGIN SET @INDEX = CHARINDEX(@DELIMETER, @TEXT) IF (@INEX = 0) AND (LEN(@TEXT) > 0 ) BEGIN INSERT INTO @STRINGS VALUES (@TEXT) BREAK END IF (@INDEX >1) BEGIN INSERT INTO @STRI..