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 vote219 views1 answer
Query for backup a database at another location in file system
SQL
0 vote204 views2 answers
Clear window pl sql
SQL
1 vote208 views1 answer
"i_am_a_dummy flag" in MySQL
SQL
0 vote205 views1 answer
Power bi find all ids not in other tables
SQL
0 vote185 views1 answer
Sqlite3 now
SQL
0 vote190 views1 answer
Mysql with
SQL
3 votes199 views1 answer
MySQL DELETE JOIN
SQL
0 vote227 views1 answer
TSQL Code Snippet For Optimized Sales Query
SQL
16 votes206 views3 answers
MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote202 views1 answer
Get enginge db mysql
SQL