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

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