my $sql = qq{ SELECT server_id FROM wms_rf_server WHERE server_name = 'splwebdev.unix.us.tld.com' }; my($server_id) = $dbh->selectrow_array($sql);