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

8 votes275 views1 answer
Sql remove characters from string right
SQL
0 vote293 views1 answer
Oracle sql drop table
SQL
0 vote308 views1 answer
Create_engine sqlalchemy with parsed url sql server
SQL
3 votes300 views2 answers
Sqlite print all column names
SQL
4 votes292 views3 answers
How to describe a table in sqlite3
SQL
1 vote291 views1 answer
Import sql file mysql commadn line
SQL
0 vote311 views2 answers
Mysql where in maintain order group_concat
SQL
4 votes300 views4 answers
Print pl sql
SQL
3 votes286 views1 answer
Postgres update column with value from another table
SQL
0 vote288 views3 answers
Group_concat sql server
SQL