Sql Split string function

CREATE FUNCTION [dbo].[Func_SplitString] 
( @Values VARCHAR(MAX)
, @splitStr VARCHAR(50)
)

RETURNS @Result_Table TABLE
       (
	     [value] nvarchar(MAX) NULL
       )
BEGIN
    DECLARE @TempStr nvarchar(MAX)
    WHILE (CHARINDEX(@splitStr,@Values)>0)
    BEGIN
        SET @TempStr=SUBSTRING(@Values,1,CHARINDEX(@splitStr,@Values)-1)
        INSERT INTO @Result_Table (value) VALUES (ltrim(rtrim(isnull(@TempStr, ''))))
        SET @Values = REPLACE(@Values,@TempStr+@splitStr,'')
    END/*End While*/
	
    IF(LEN(RTRIM(LTRIM(@Values)))>0 AND CHARINDEX(@splitStr,RTRIM(LTRIM(@Values)))=0) 
    BEGIN
        SET @TempStr=@Values 
        INSERT INTO @Result_Table (value) VALUES (ltrim(rtrim(isnull(@TempStr, ''))))
    End /*End IF*/
   RETURN 
END

Similar codes

13 votes217 views3 answers
Uninstall mysql centos 7
SQL
1 vote232 views1 answer
Oracle split string
SQL
24 votes246 views4 answers
Postgres remove database
SQL
5 votes225 views1 answer
Oracle asynchronous query
SQL
0 vote234 views1 answer
Call rest api from postgresql
SQL
1 vote267 views1 answer
Mysql update inner
SQL
0 vote258 views1 answer
Load data infile mariadb slow
SQL
0 vote245 views1 answer
SQL SELECT-Klausel
SQL
0 vote233 views1 answer
Sql "List the contact methods found in the Contact table.For each contact method, list how many people chose that contact method."
SQL
0 vote233 views1 answer
Sql select rows with different values in one column
SQL