Easiest way to Duplicate records and change only ONE field

I have a database table with X number of fields.
I need to read all the records where “KEY=‘A’” and duplicate them with “KEY=‘B’”
preferably without having to list all the other myriad of fields

select all into a temp table create table tempwork as select * from original
alter the fieid using updates update tempwork set Key = 'B'
insert back to original by selecting all from the temp insert into original select * from tempwork
drop the temp drop table tempwork

yeah, thats what I ended up doing :slight_smile: Thanks

did have to set the PK in the temp table to NULL to avoid constraint violations

that makes sense as well