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 vote134 views1 answer
Sql create table with datetime automatically
SQL
0 vote125 views1 answer
Mysql server not starting in xampp in mac
SQL
0 vote145 views1 answer
System.Data.SqlClient.SqlException: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' SqlDataAdapter
SQL
0 vote132 views1 answer
Sql recherche nom prenom
SQL
3 votes135 views2 answers
Postgres show table schema
SQL
0 vote159 views1 answer
Mysql equivalent decode oracle
SQL
0 vote129 views1 answer
Sql find leading space
SQL
0 vote86 views1 answer
'0000-00-00' for column '
SQL
1 vote131 views1 answer
Sql first
SQL
0 vote90 views1 answer
Postgresql subquery
SQL