$PTName =~ s/,/','/g; if ($PTName) { $Where = $Where . "AND E.PT_name IN ANY ($PTName) "; } #### isc01cfa,isc02cfa isc03ifa,isc04ifa #### ..........AND E.PT_name IN ANY ('isc01cfa','isc02cfa'',''isc03ifa','isc04ifa')
## isc01cfa,isc02cfa isc03ifa,isc04ifa ##
## ..........AND E.PT_name IN ANY ('isc01cfa','isc02cfa'',''isc03ifa','isc04ifa')