my $query; foreach (keys %parms){ $query .= "'$_ '" . " = " . '"' . $parms{$_} '"' . " if $parms{$_}; }