Split Strings With SQL

Create function SplitString (@String varchar(4000), @Delimiter varchar(1))
Returns @Results Table (Items varchar(4000))
As
Begin
Declare @StartIndex int
Declare @Slice nvarchar(4000)

Select @StartIndex = 1
If @String Is NULL Return
While @StartIndex != 0
Begin
Select @StartIndex = CharIndex(@Delimiter, @String)
If @StartIndex != 0
Select @Slice = left(@String, @StartIndex - 1)
else
Select @Slice = @String
Insert into @Results(Items) Values (@Slice)
Select @String = right(@String, Len(@String) - @StartIndex)
If Len(@String) = 0
break
End
Return
End