select case t.Region
when '1' then 'Asia Pacific'
when '2' then 'Europe, Middle East, & Africa'
when '3' then 'North America'
when '4' then 'South America'
else t.Region
end as region
from TempRegion t