CREATE FUNCTION dbo.SplitString(@StringValue varchar(2000), @Delimiter char(1))
returns
@resulttable TABLE (words
varchar(2000))
as
begin
declare @index int
declare @sliceOfStringValue varchar(2000)
set @index = 1
if len(@StringValue)<1 or
@StringValue is null return
while @index!= 0
begin
set @index = charindex(@Delimiter,@StringValue)
if @index!=0
set
@sliceOfStringValue = left(@StringValue,@index - 1)
else
set @sliceOfStringValue =
@StringValue
if(len(@sliceOfStringValue)>0)
insert into @resulttable(words) values(@sliceOfStringValue)
set @StringValue = right(@StringValue,len(@StringValue) - @index)
if len(@StringValue) = 0 break
end
return
end