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 vote286 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL
1 vote199 views1 answer
Reutrn string after character sql
SQL
0 vote213 views1 answer
MySql count occurences more than"
SQL
1 vote210 views1 answer
Mysql select row max date
SQL
0 vote192 views1 answer
Mysql isshow
SQL
0 vote209 views1 answer
Date on SQL
SQL
0 vote256 views1 answer
Tsql find procedure with name
SQL
16 votes229 views1 answer
Sql comment'
SQL
0 vote163 views1 answer
Alter session set nls_language french
SQL
0 vote196 views1 answer
Psql check if value in array
SQL