- or download this
WHERE ... AND ((CLName LIKE 'A%') OR (CLName in ('MET-CL1','BDO-CL1'))
- or download this
if ($clnm) {
@parts = split /,/,$clnm;
map { m/\'\w\'/ ? push @pre, $_ : push @words, $_ } @parts;
- or download this
$in_clause = sprintf "( CLName IN (%s) )", join ',',@words;