Hi all
In a sql table, i would like to insert a subset but changing the value in just 1 field.
I have a table with fields field1, field2, field3. I would like to select all rows with value 5 in field1, and insert the result rowset but changing the value of field1 to 6 prior to inserting. Is it doable in one insert command?

Thanks
Jaime