>>>It can be done in many ways (shown in the order of my personal preferences) :
>>>1. Using XML. See Re: IN and char versus int Thread #833306.
>>>2. Using fn_split() function from http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlmag01/html/TreatYourself.asp to convert a list into a table and than use derived table in your select
>>>3. Use dynamic sql.

DECLARE @Sql nvarchar(4000)
>>>SET @Sql = 'SELECT ... WHERE column in (' + @ListParam + ')'
>>>EXECUTE(@Sql)

>>
>>Tip #2 could had saved me some hair a while back.... I ended up rolling my own udf for this.
>
>I also published ufn_Alines() in Utmag.

And at http://www.berezniker.com/display/SQL/Alines+UDF+-+String+Split