using a case statement
When using case statments i have the following:
CASE
WHEN ( SELECT SUBSTR (global_name, 1, 8) FROM global_name) LIKE
'%2%'
THEN
'PNC'
WHEN campus LIKE '%FW'
THEN
'PNC'
WHEN CAMPUS LIKE 'T%'
THEN
'PNC'
WHEN CAMPUS = 'CEC'
THEN
'PNC'
WHEN CAMPUS = 'LCF'
THEN
'PNC'
WHEN CAMPUS = 'WCF'
THEN
'PNC'
ELSE
CAMPUS
END
How can I reduce the amount of when statements so I can use a wild card so no matter what the value is I will set it to PNC.
thanks
0