数据库截取字符串的函数

​Create Function [dbo].[ufn_Split]
(
@content varchar(8000),
@seperator varchar(20)
)
RETURNS @temp table
(
Value VARCHAR(8000)
)
BEGIN
declare @CurrIndex int, @NextIndex int
select @CurrIndex = 1
select @NextIndex = 1
select @NextIndex=charindex(@seperator, @content)
while (@NextIndex > 0)
begin
if (@NextIndex >= @CurrIndex+1)
begin
insert into @temp (Value) values (substring(@content, @CurrIndex, @NextIndex-@CurrIndex))
end
select @CurrIndex = @NextIndex + 1
select @NextIndex=charindex(@seperator, @content, @CurrIndex)
end
if @CurrIndex <= datalength(@content)
insert into @temp (Value) values (substring(@content, @CurrIndex, datalength(@content)-@CurrIndex+1))
return
END
GO