Split string using delimiter in sql server

 Create Function [dbo].[SplitString](@String varchar(8000), @Delimiter char(1))  
 returns @temptable TABLE (items varchar(8000),id int)  
 as  
 begin  
 declare @idx int  
 declare @idy int  
 declare @slice varchar(8000)  
 set @idy=1  
 select @idx = 1  
 if len(@String)<1 or @String is null return  
 while @idx!= 0  
 begin  
 set @idx = charindex(@Delimiter,@String)  
 if @idx!=0  
 set @slice = left(@String,@idx - 1)  
 else  
 set @slice = @String  
 if(len(@slice)>0)  
 insert into @temptable(id,Items) values(@idy, @slice)  
 set @idy=@idy+1  
 set @String = right(@String,len(@String) - @idx)  
 if len(@String) = 0 break  
 end  
 return  
 end