SQL语句一个简单的字符串分割函数

CREATEFUNCTIONdbo.f_splitstr(
@strvarchar(8000)
)RETURNS@rTABLE(idintIDENTITY(1,1),valuevarchar(5000))
AS
BEGIN
/*Functionbody*/
DECLARE@posint
SET@pos=CHARINDEX(",",@str)
WHILE@pos>0
BEGIN
INSERT@r(value)VALUES(LEFT(@str,@pos-1))
SELECT
@str=STUFF(@str,1,@pos,""),
@pos=CHARINDEX(",",@str)
END
IF@str>""
INSERT@r(value)VALUES(@str)
RETURN

END

select*fromf_splitstr("中,国,人")