setting up a Sql Stored Procedure to accept an array as a parameter...

Ok, I'm not sure the title is exactly right, so let me explain better what it is I'm trying to do this fine evening.  :)

So I have this Sql Report Services report that takes a input parameter that is currently in a combobox at the top of the report.  It then feeds the value of this drop down list into my stored procedure and produces the data.

One of the abilities of this combo box is to be a multi-select type.  I want to setup my stored procedure to be able to take the mutli-select input...but I'm not sure how to go about doing it.

For example, if the multi-select Combobox has the values 1 through 3...if all of them selected, the string value of that Combobox would be "1, 2, 3" which is currently getting passed into my stored procedure, which blows up because it doesn't understand what to do with the comma's.

I want to make my stored procedure more intelligent and be able to handle a comma delimited array of values.  The problem is I'm not sure what this type of thing is called so I don't what I'm looking for, hehehe...  It's always comes down to just knowing where to look for info doesn't it...hehehe.

Well, as always if anyone has any suggestions for me, I'm all eyes.  :)  Until then I'll keep digging.