Lafras Henning wrote:

> But you must agree that in modern times with the sophistication of SQL
> it is strange that there is not an easier standard means to copy a
> couple of fields.

If you use EXECUTE BLOCK or a stored procedure and you use FlameRobin,
just right-click the table in the tree and select the "Generate
selectable procedure" option. It will do some of the hard work for you
(declaring variables and writing the select statement). All you have to
do is write the update statement then.

I believe other admin. tools have similar options, so if you use
something else, investigate it a little bit.

--
Milan Babuskov
http://www.flamerobin.org