SQL Server String splitting statement

Copy codeThe Code is as follows:
--> Title: generate a sequence number.
--> Author: wufeng4552
--> Date: 09:02:08
If object_id ('f _ split ') is not null drop function f_split
Go
Create function f_split
(
@ S varchar (8000), -- string to be split
@ Split varchar (10) -- Data Separator
) Returns table
As
Return
(
Select substring (@ s, number, charindex (@ split, @ s + @ split, number)-number) as col
From master .. spt_values
Where type = 'p' and number <= len (@ s + 'A ')
And charindex (@ split, @ split + @ s, number) = number
)
Go
Select * from dbo. f_split ('11, 2, 3 ',',')

/*
Col
----
11
2
3
(3 data columns are affected)
*/