I do exactly that in one of my programs but for an INSERT statement. a la

My @values # get updated/pushed on whatever--sometimes an arrayref fro
+m a selectall_arrayref on another DB of a different subtype
$dbh->do("insert into table1 (col2, col3, col4) values('",join("','",@
+values),"')");
[download]

Well, something like that. I think by now I've refactored it to set a variable with the join and just interpolate that into the quoted SQL command just as in the post above.

_________________________________________________________________________________

I like computer programming because it's like Legos for the mind.