SQL delimiter string Function

-- SQL statement used to call and query string functions

-- The output result is a data table.

Declare @ strprimarykey nvarchar (500)
Set @ strprimarykey = '1, 2, 3, 4, 5, 6, 7'
Declare @ strplitchar nvarchar (10)
Set @ strplitchar = ','
Declare @ strreturn nvarchar (500)

Select * From DBO. fun_splitstr (@ strprimarykey, @ strplitchar)

-- SQL delimiter string Function
Create Function DBO. fun_get_splitstr
(
@ Sourcesql varchar (8000 ),
@ Strseprate varchar (100 ))
Returns @ temp table (F1 varchar (100)
)
As
Begin
Declare ch as varchar (100)
Set @ sourcesql = @ sourcesql + @ strseprate
While (@ sourcesql <> '')
Begin
Set @ CH = left (@ sourcesql, charindex (',', @ sourcesql, 1)-1)
Insert @ temp values (@ ch)
Set @ sourcesql = stuff (@ sourcesql, 1, charindex (',', @ sourcesql, 1 ),'')
End
Return
End