Side comments. It's best not to use dynamic SQL. ANY is an optional keyword which most people leave out (and thus might cause confusion if left in.) If the list were static, the clause could be: AND E.PT_name LIKE 'isc0__fa'. Without context it is hard to tell if something similar would apply in your case.