CREATE FUNCTION dbo.SplitString(@StringValue varchar(2000), @Delimiter char(1))
Loading
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
Join the conversation! Your thoughts help the community grow.