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 vote404 views1 answer
Sql server query all database objects
SQL
0 vote375 views1 answer
Select a row include list of array with join table SQL
SQL
1 vote341 views2 answers
T-sql random number for each row
SQL
0 vote359 views1 answer
Raven ql select count
SQL
28 votes374 views6 answers
Mysql change user password
SQL
0 vote352 views1 answer
Mysql shell set time_zone
SQL
1 vote395 views2 answers
Oracle difference between two dates in seconds
SQL
0 vote393 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL
2 votes379 views1 answer
Ifnull postgres
SQL
0 vote372 views1 answer
Get schema of table sql
SQL