TSQL function split string

CREATE FUNCTION FUNC_Split](@text VARCHAR(8000), @delimiter VARCHAR(20) = ' ')
RETURNS @Strings TABLE
(   
  position INT IDENTITY PRIMARY KEY,
  value VARCHAR(8000)  
)
AS
BEGIN
DECLARE @index INT
SET @index = -1

WHILE (LEN(@text) > 0)
  BEGIN 
    SET @index = CHARINDEX(@delimiter , @text) 
    IF (@index = 0) AND (LEN(@text) > 0) 
      BEGIN  
        INSERT INTO @Strings VALUES (@text)
          BREAK 
      END 
    IF (@index > 1) 
      BEGIN  
        INSERT INTO @Strings VALUES (LEFT(@text, @index - 1))  
        SET @text = RIGHT(@text, (LEN(@text) - @index)) 
      END 
    ELSE
      SET @text = RIGHT(@text, (LEN(@text) - @index))
    END
  RETURN
END

Similar codes

1 vote287 views3 answers
Grant syntax in sql
SQL
0 vote306 views1 answer
Cannot create a JSON value from a string with CHARACTER SET 'binary'.
SQL
-3 votes385 views8 answers
Sql to c# linq converter online
SQL
0 vote297 views2 answers
Identity column in sql server
SQL
0 vote314 views1 answer
Wp_query raw sql
SQL
0 vote324 views1 answer
Mariadb create index if not exists
SQL
0 vote289 views1 answer
Can we rollback data that are deleted using DELETE
SQL
9 votes290 views4 answers
Last mysql
SQL
0 vote285 views1 answer
Flask sqlalchemy decimal
SQL
65 votes514 views6 answers
Sql add column to table
SQL