We faced this problem a while back at our company as well.  And one of our DBAs came up with the following solution:

WHERE (@CommaDelimtedList + ',' LIKE '%'+ TableColumnToCompareTo + ',%'...