my $name = $dbh->quote("O'Brien"); $sth = $dbh->prepare("SELECT SUM(number) FROM $serverTable where name = $name);