Va la funcion
CREATE FUNCTION SplitCadena ( @cadena VARCHAR(MAX) ,@separator VARCHAR(MAX) ) RETURNS @tabla TABLE ( value VARCHAR(MAX) ) BEGIN
DECLARE @individual varchar(max) = null
WHILE LEN(@cadena) > 0 BEGIN IF PATINDEX('%' + @separator + '%',@cadena) > 0 BEGIN SET @individual = SUBSTRING(@cadena, 0, PATINDEX('%' + @separator + '%',@cadena)) INSERT INTO @tabla values(@individual)
SET @cadena = SUBSTRING(@cadena, LEN(@individual + @separator) + 1, LEN(@cadena)) END ELSE BEGIN SET @individual = @cadena SET @cadena = NULL INSERT INTO @tabla values(@individual) END END;
RETURN; END GO