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 vote139 views1 answer
Redshift running queries
SQL
1 vote155 views1 answer
Mysql current running queries
SQL
1 vote135 views1 answer
Sql server update column based on another table
SQL
0 vote130 views1 answer
Exit psql
SQL
1 vote128 views1 answer
Postgres regex remove special characters
SQL
1 vote129 views1 answer
Multiple count in sql
SQL
23 votes161 views6 answers
Create table sql
SQL
0 vote129 views1 answer
Sql find record cannot cast date
SQL
0 vote196 views1 answer
Duplicate table: 7 ERROR: relation "migrations" already exists (SQL: create table "migrations" ("id" serial primary key not null, "migration" varchar(255) not null, "batch" integer not null))
SQL
0 vote133 views1 answer
Mysql local password denied
SQL