Ya - what Si said - works fine for me

insert into TableA (12 ,Field B)
values (select * from TableA where key = 10)


If you wanted to get really really yucky about it you could insert into a temporary table, run an update statement to change the 10 to a 12, and then move the rows back to TableA but why bother. (Whoops - this is exactly as GM described).