my $iNumber;
prepare("SELECT number FROM table WHERE number = $iEnteredNumber")
( $iNumber ) = fetchrow_array();
finish();

if ( defined( $iNumber ) ){
  redirect("error.pl");
  exit;
}

#more stuff done here

redirect("success.pl");