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 vote318 views1 answer
Kimball data warehouse sql calendar
SQL
9 votes264 views4 answers
How to remove duplicate in sql
SQL
0 vote263 views1 answer
Find most frequent value in SQL column
SQL
3 votes276 views3 answers
Sql last week
SQL
2 votes263 views4 answers
How to find 2nd highest salary in mysql
SQL
0 vote295 views1 answer
How to connect to xampp sql server on windows cmd
SQL
-1 vote286 views1 answer
SQL SERVER microsoft How to Add Column at Specific Location in Table
SQL
5 votes254 views1 answer
How to check nls timestamp format in oracle
SQL
1 vote269 views1 answer
Sql server 2016 reseed identity
SQL
1 vote284 views1 answer
ERROR 1193 (HY000): Unknown system variable 'GTID_PURGED'
SQL