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

5 votes186 views1 answer
Find table from column name in sql
SQL
1 vote179 views1 answer
Postgres convert exisiting column to text
SQL
1 vote185 views2 answers
Mysql grant all privileges on *.* to 'root'@' ' identified by
SQL
0 vote210 views1 answer
Consecutive numbers sql
SQL
2 votes193 views1 answer
Show max_allowed_packet mysql
SQL
1 vote168 views1 answer
Mysql server does not start mac
SQL
0 vote181 views1 answer
Mysql coonect sample code
SQL
0 vote177 views1 answer
Mysql query with sql to get the next row
SQL
4 votes182 views1 answer
Data types in sql
SQL
0 vote177 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL