quote:

---

Originally posted by kt

Hi,

The region table is stored the values for:
regionName
============
UNITED STATES
2
INDIA
3
HONG KONG
1
4

if regionName has the value as #, then I want to replace that number with the name, else just keep the name (UNITED STATES,INDIA,HONG KONG)

select [customer],
case regionName
when 1 then 'Asia Pacific'
when 2 then 'Europe, Middle East, & Africa'
when 3 then 'North America'
when 4 then 'South America'
else regionName
END AS region
from [dbo].[region]

thanks

---

SELECT  [customer] ,
        CASE WHEN regionName = '1' THEN 'Asia Pacific'
             WHEN regionName = '2' THEN 'Europe, Middle East, & Africa'
             WHEN regionName = '3' THEN 'North America'
             WHEN regionName = '4' THEN 'South America'
             ELSE regionName
        END AS region
FROM    [dbo].[region]

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

region
=============================
UNITED STATES
Europe, Middle East, & Africa
INDIA
North America
HONG KONG
Asia Pacific
South America