Splitting variables in stored procedures

[MattDavies51]

I am passing a parameter(varchar) into a stored procedure that contains several values, and I was wondering whether SQL Server allows you to split the parameter/variable into the separate values. eg. say "Red, Blue, Green, Yellow" is passed as one parameter, I would like to break this down into 4 variables.

I know about the substring/left/right/mid functions but I am looking for something similar to the split function in VB.

Please help.

 

[ClaireHCM]

As far as I know,there is no split function as you describe.
So you could only use round-about method.
The round about method can be choosed from string functions