note manorhce <p>Please try with the below it is working for me</p> <code>@values = map( { $_->[0] } @{ $dbh->selectall_arrayref($sql) } );</code> <p>Please provide</p> 387942 387942