my @col_names = qw/first_name middle_name last_name address phone_number/; my $total_len = join '+', map { "char_length($_)" } @col_names; my $sql = "SELECT $total_len AS 'Row Length' FROM table ORDER BY $total_len";