Hallo, to the original joke, why not to return desired result directly like this?

-- insert into SOURCE

select [Name], Age, case(Sex) when 'M' then 'm' else 'f' end

from (

select * ,...