select * from stuff update stuff set TYPE1 = TYPE2 where TYPE1 is null; update stuff set TYPE1 = TYPE2 where TYPE1 ='Blank'; select * from stuff