How To Split A Delimeted String...

 hi,

i have a simple question, i have a sql server table named "Restaurant" and a field "Cuisines",

the values in the field Cuisines contains delimeted string. (e.g. "C1,C2,C3...C10" ,maximum to 10 items or less)

now, i want to split the values from Cuisines ("C1,C2,C3...C10") and passed all of them to a SP parameter.

e.g


@item0 nvarchar = "C1",
@item1 nvarchar = "C2",
@item2 nvarchar = "C3",
@item3 nvarchar = "C4",
@item4 nvarchar = "C5",
@item5 nvarchar = "C6",
@item6 nvarchar = "C7",
@item7 nvarchar = "C8",
@item8 nvarchar = "C9",
@item9 nvarchar = "C10"

 if the field "Cuisines" contains less than 10 items, the value of the remaining parameters is null.

any response will be appreciated. thanks.