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

11 votes377 views2 answers
Oracle source code
SQL
1 vote363 views1 answer
Set id count mysql
SQL
0 vote347 views2 answers
Search stored procedures
SQL
-1 vote325 views1 answer
Ssms connect with connection string
SQL
1 vote326 views2 answers
How to check username in mysql command line
SQL
0 vote317 views1 answer
Html css mobile menu arrow dropdown
SQL
0 vote332 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL
1 vote360 views1 answer
Sqlserver create table from select
SQL
3 votes346 views2 answers
How to list columns for particular tables in postgresql
SQL
0 vote339 views2 answers
What is the library that should import to use all functional database features in SQLite?
SQL