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

16 votes231 views4 answers
Find duplicates mysql
SQL
0 vote242 views1 answer
Where to find pg_hba.conf in ubuntu
SQL
0 vote224 views1 answer
Postgres enumerated type
SQL
0 vote234 views1 answer
Install squirrel sql ubuntu
SQL
10 votes229 views2 answers
Show tables in schema oracle
SQL
-1 vote234 views1 answer
Concat two columns in sql server
SQL
4 votes263 views4 answers
Mysql get date from datetime
SQL
4 votes208 views2 answers
What is table in sql
SQL
1 vote235 views1 answer
Select not matching data with join table
SQL
3 votes238 views2 answers
How to open postgresql in windows
SQL