Thanks for the reply Sergey
These table are subject to frequent addition of columns, so I was hoping to find a way to do it without specifying all the columns - something like SCATTER and GATHER
NSERT INTO mytable
SELECT col1, col2, <newValueCol3>, col4, col5, ...
FROM mytable
WHERE Col3 = <ValueCol3>, ColN = <ValueColN>
>I need to select a set of rows from a table, based on two columns
>, give one of those columns a new value in the selected set, and then insert the selected set into the source table.
>I can bring them down from the server, do the changes and then insert them one at a time, but I'm not crazy about that all those trips to and from the server, I'd rather do it all on the server, but can't figure out how
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.