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 vote204 views2 answers
List all the items that have not been part of any purchase order. sql
SQL
12 votes206 views3 answers
Duplicate a column in sql
SQL
0 vote226 views1 answer
Into operator in sql
SQL
0 vote244 views1 answer
Mysql error 1114 (hy000) the table is full
SQL
0 vote265 views1 answer
Sql query to select even numbers
SQL
0 vote263 views1 answer
Copy from one table to another postgres using matching column
SQL
0 vote211 views1 answer
Minecraft duping allowed servers
SQL
0 vote216 views1 answer
Mysql drop trigger
SQL
0 vote241 views1 answer
View t-sql mail configuration
SQL
1 vote248 views1 answer
Find size of all DB's postgres
SQL