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 + ',%' OR @CommaDelimtedList = '')

Just thought I'd share with everyone how we handle this situation.