If you use placeholders, you don't have to worry about escaping.

$sth2 = $dbh->prepare("SELECT SUM(number) FROM $serverTabl_4 where nam
+e = ?");
$sth2->execute("O'Connor");
[download]

-- Randal L. Schwartz, Perl hacker