PCB MS SQL splits a string into a table variable (table-valued function)

Create  FUNCTION [dbo].[splittable](@s   varchar(Max),--string to be split@split varchar(Ten)--Data Separators)RETURNS @re TABLE(IDint IDENTITY(1,1), colvarchar(Max))--Create a temporary table save the split character asBEGIN     DECLARE @splitlen int     SET @splitlen=LEN(@split+'a')-2      while CHARINDEX(@split,@s)>0     BEGIN        INSERT @re VALUES( Left(@s,CHARINDEX(@split,@s)-1))        SET @s=STUFF(@s,1,CHARINDEX(@split,@s)+@splitlen,"')     END     INSERT @re VALUES(@s)     RETURNEND

Example:

SELECT *  from [dbo]. [splittable] (' tin spray, immersion gold, gold-plated, OSP',',')

PCB MS SQL splits a string into a table variable (table-valued function)