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

1 vote132 views1 answer
Query for all indexes in table postgres
SQL
1 vote139 views1 answer
Get current date in pyspark sql
SQL
1 vote124 views2 answers
Sql server concat string and int
SQL
-1 vote127 views1 answer
Phinehas Psalm 106
SQL
2 votes120 views4 answers
Mysql get all tables row count
SQL
0 vote123 views5 answers
Mode sql course
SQL
6 votes119 views2 answers
Stored procedure to delete data from table in mysql
SQL
8 votes135 views4 answers
Convert date to dd/mm/yyyy sql
SQL
0 vote121 views1 answer
Sql column contains special character
SQL
0 vote111 views1 answer
Sql server check whether column has same equal values
SQL