my $found = $dbh->selectrow_arrayref(q{
   select 1 from employee
   where employee_number = ?
},undef, $search_for_id);

<do something> unless $found->[0];

# now get the record