Can LIKE be used inside a CASE stmt? 1

[Sheffield]

I don't think so, and I feel stupid for asking, but I need confirmation.

Consider the following code where I would like to control the output of many different spellings of 'Pittsburgh' in different fields:

SELECT Name, Addr1, Addr2,
   CASE City
     WHEN

like 'Pitt%'

 THEN ("Pittsburgh")
        ELSE (City) END as "City",
       State, Zip
FROM tblTableA

I receive syntax errors using this code. Is there a method by which I can achieve the same result, without detailing every possible spelling?

 

[plantj]

Sheffield,

You simply have a syntax error...

select
case
when city like 'pitt%' then
'Pittsburgh'
else
city
end
,state
,zip
from
tblTableA