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 vote177 views1 answer
Set a value by excuting stored procedure
SQL
1 vote166 views1 answer
Sql select contem uma palavra
SQL
2 votes119 views1 answer
Oracle current date without time
SQL
2 votes170 views1 answer
How to find constraints on a table in oracle
SQL
1 vote171 views1 answer
Where database run
SQL
0 vote161 views1 answer
Mysql database is not starting in xampp
SQL
1 vote202 views1 answer
Sql random sampling per group
SQL
2 votes191 views1 answer
Sql finding longest and shortest names in a fleld
SQL
0 vote180 views1 answer
Plpgsql coalesce equivalent for empty string
SQL
5 votes136 views1 answer
Alter table default value mysql
SQL