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 vote117 views1 answer
Sql select column names starting with
SQL
-1 vote137 views2 answers
Sql search all tables for attributes
SQL
5 votes118 views2 answers
Sql number columns
SQL
1 vote117 views1 answer
Sql server 2016 reseed identity
SQL
-1 vote115 views1 answer
Mysql delete duplicate rows except one
SQL
0 vote115 views1 answer
Drop index in sql
SQL
0 vote121 views1 answer
Sql select with apostrohpe
SQL
0 vote118 views1 answer
How to read the potentail error messages in ssis package
SQL
13 votes122 views2 answers
Oracle select into and inner join
SQL
12 votes126 views2 answers
Select into insert sql server
SQL