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,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[txdave35]

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