Need Help Creating Case Statements

[txdave35]

Hi guys,

Can someone show me the DB2 structure for creating multiple CASE statments in the same query? I wrote this query, but I get syntax errors:

SELECT RECIP_SSN_NBR,

CASE WHEN BENEF_STAT_CD = 'AC' THEN 'ACTIVE' ELSE 'INACTIVE' END AS TEST,
CASE WHEN BENEF_STAT_CD = 'DP THEN 'DROP' ELSE 'INACTIVE' END AS TEST2


FROM DSNP.PR01_T_RECIP_SYS


Thanks.

 

[SkipVought]

Hi,

missing a TIC...

CASE WHEN BENEF_STAT_CD = 'DP[red][b]'[/b][/red]  THEN 'DROP' ELSE 'INACTIVE' END AS TEST2

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[txdave35]

Thanks Skip! I feel stupid, but glad I was close