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 vote97 views1 answer
Where date = max(date) in sql
SQL
0 vote107 views1 answer
Use mysql in java program
SQL
13 votes118 views5 answers
Sql default
SQL
2 votes113 views1 answer
Create mysql user on all hosts
SQL
0 vote100 views1 answer
2020 new year
SQL
10 votes141 views4 answers
Sql server pagination
SQL
7 votes123 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL
3 votes118 views1 answer
Export postgres database linux
SQL
4 votes105 views2 answers
Oracle last day of month
SQL
2 votes92 views1 answer
Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column \\ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL