I'm running against Oracle. My query works fine with these small chages to Oracle syntax:

WHERE (:CommaDelimtedList || ',' LIKE '%' || TableColumnToCompareTo || ',%' OR @CommaDelimtedList = '')

However when I run the query in Reporting Services 2005 Sp2, if I choos more than one item in the multiselect, I get the error

"ORA-00920 Invalid relational operator"

Any idea what is happening?