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

Yup, because
select username from user where address=foo@ebi-llc.com
isn't valid SQL. Use a place holder:
my $sql = qq(select username from user where address=?); my $sth1 = $dbh->prepare($sql); $sth1 -> execute ($address);

Abigail