in reply to Can't pass email address in SQL select statement

davart,
Try it using placeholders.
my $sth1 = $dbh->prepare("select username from user where address=?"); $sth1->execute($address);
Using placeholders can avoid all kinds of pitfalls.

Cheers - L~R