my $ref = $dbh->selectcol_arrayref( "SELECT MAX(LineID) FROM tbl" ); my $LineID = $$ref_booking[0];