sqlserver split函数

CREATE FUNCTION F_SplitSTR(
@string        varchar(8000),  --待分拆的字符串
@symbol        varchar(10)     --数据分隔符
)RETURNS @table TABLE(col varchar(100))
AS
BEGIN
    DECLARE @splitlen int
    SET @splitlen=LEN(@symbol)-1
    WHILE CHARINDEX(@symbol,@string)>0
    BEGIN
        INSERT @table VALUES(LEFT(@string,CHARINDEX(@symbol,@string)-1))
        SET @string=STUFF(@string,1,CHARINDEX(@symbol,@string)+@splitlen,'')
    END
    INSERT @table VALUES(@string)
    RETURN
END
GO