>insert into MyTable (Column1, Column2, Column3 ) > select case when SomeColumn = 'Use Column1a' then Column1a else Column1b end as Column1, Column2, Column3 From SomeOtherTable >