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

2 votes296 views1 answer
Alter table add multiple columns postgresql
SQL
2 votes304 views1 answer
Columns Present in a table
SQL
0 vote299 views1 answer
Drop all triggers oracle
SQL
-1 vote298 views3 answers
Mysql get age from date
SQL
5 votes294 views1 answer
Migrate sql table another database
SQL
5 votes292 views3 answers
Mysql check if null or empty string
SQL
11 votes290 views2 answers
MySQL DISTINCT
SQL
7 votes322 views2 answers
Mysql Public Key Retrieval is not allowed
SQL
0 vote275 views1 answer
Sql requete number pair
SQL
22 votes333 views3 answers
Year format in date mysql
SQL