CREATE FUNCTION C_split(
@String Nvarchar(Max),
@Sing Nvarchar(10)
)
RETURNS @Table TABLE(a Nvarchar(100))
AS
BEGIN
DECLARE @i int
SET @String=rtrim(ltrim(@String))
SET @i=charindex(@Sing,@String)
WHILE @i>=1
BEGIN
INSERT @Table
VALUES
(
LEFT(@String,@i-1)
)
SET @String=substring(@String,@i+1,len(@String)-@i)
SET @i=charindex(@Sing,@String)
END
IF @String<>'\'
INSERT @Table
VALUES
(
@String
)
RETURN
END
SELECT *
FROM dbo.C_split('1,2,3,4,5,6',',')
