sql逗号分隔字符串转化成table的函数

/*
	select * from dbo.f_split('1,2,3,4,5,', ',')
*/
create function [dbo].[f_split] 
--alter function [dbo].[f_split] 
(
	@source varchar(8000),
	@seprate varchar(10)
)
returns @temp table(item varchar(100))
	--实现split功能 的函数
as 
begin

	declare @i int
	set @source = rtrim(ltrim(@source))

	set @i= charindex(@seprate, @source)
	while @i >= 1
	begin
		insert @temp values(left(@source, @i-1))
		set @source = substring(@source, @i + 1, len(@source) - @i)
		set @i = charindex(@seprate, @source)
	end

	if @source <> '\' and @source<>''
	insert @temp values(@source)

	return 
end