my $arrayref = $dbh->selectcol_arrayref(qq/ SELECT $myColumn FROM $myTable /); my @array = @{$arrayref};