my $string = "SELECT [col 1], [col 2], col3 ...";

##</code><code>##

my $value1 = $RS->Fields("col 1")->value;