my $emp_exists_sth = $dbh->prepare_cached(q{
 select 1 from employee
 where employee_number = ?
});
...
my $found = $dbh->selectrow_array($emp_exists_sth, undef, $search_for_id);
print "Not found\n" unless $found;