sqlserver-函数-分隔逗号的字符串

USE [PPMS]
GO
/****** Object:  UserDefinedFunction [dbo].[F_Split]    Script Date: 2016/4/20 17:47:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER FUNCTION [dbo].[F_Split](@Str varchar(4000),@Tag varchar(2))
RETURNS @T TABLE(Value varchar(100)) --bigint 
AS
BEGIN
Declare @Str1 bigint 
Declare @newStr varchar(4000) 
set @Str=@Str+@Tag
while(len(@Str)>0)
begin
   set @Str1 = left(@str,charindex(@Tag,@str)-1) --cast(left(@str,charindex(@Tag,@str)-1) as bigint)
   Insert @T Values(@Str1)
   set @Str = stuff(@Str,1,charindex(@Tag,@Str),'')
end
RETURN
END