$sql = sprintf "SELECT foo FROM bar WHERE baz = %s", $dbh->quote("Don't");

##</code><code>##

$sql = "SELECT foo FROM bar WHERE baz = " . $dbh->quote("Don't");