UDF to return a multi column table of values from an input string

CREATE Function ListToMultiColumnTable ( @List Varchar(8000), @ColumnCount int)
Returns @Table table
(
Column1 varchar(255),
Column2 varchar(255),
Column3 varchar(255),
Column4 varchar(255),
Column5 varchar(255))
as
Begin

Declare @Value varchar(255)
Declare @Column1 varchar(255)
Declare @Column2 varchar(255)
Declare @Column3 varchar(255)
Declare @Column4 varchar(255)
Declare @Column5 varchar(255)
Declare @ColumnNumber int

While Len(@List) > 0
Begin
Set @Column1 = ''
Set @Column2 = ''
Set @Column3 = ''
Set @Column4 = ''
Set @Column5 = ''
Set @ColumnNumber = 1

while @ColumnNumber <= @ColumnCount
begin
set @Value = ''
While Left(@List,1) <> ',' and Len(@List) > 0
Begin
Set @Value = @Value + Left(@List,1)
Set @List = Right(@List,Len(@List) - 1)
End

Set @Column1 = case when @ColumnNumber = 1 then @Value else @Column1 endSet @Column2 = case when @ColumnNumber = 2 then @Value else @Column2 endSet @Column3 = case when @ColumnNumber = 3 then @Value else @Column3 endSet @Column4 = case when @ColumnNumber = 4 then @Value else @Column4 endSet @Column5 = case when @ColumnNumber = 5 then @Value else @Column5 end
Set @ColumnNumber = @ColumnNumber + 1
If Len(@List) > 0
Begin
Set @List = Right(@List,Len(@List) - 1)
End
end

Insert @Table Values(@Column1, @Column2, @Column3, @Column4, @Column5)
End
Return
End

--output example

declare @List varchar(1000)
set @List = '1,Tea,£1.50,2,Coffee,£1.75,3,Hot Chocolate,£2.05'
select * from dbo.ListToMultiColumnTable(@List, 3)