Decode in Oracle = ??? in DB2

[Guest_imported]

I would like to find the same type of query as the one listed below, only I would like to modify it for DB2:

This will change the font color of the text that appears for planned complete date based on the status of the endorsed column in the warehouse. If an activity has been either "E" or "GEM" (endorsed or government endorsed milestone) then the font is red. If the activity is "N" or not endorsed, then the font will be green for this activity. Syntax for Use for Oracle 8.

("decode(endorsed,
'E' , '<font color=red>' ||#0|| '</font>' ,
'GEM', '<font color=red>' ||#0|| '<font>',
'N' , '<font color=green>' ||#0|| '</font>',
#0)&quot;, [PLANNED_COMPLETE_DATE])

 

[thebioman]

Hey there...

Try using &quot;CASE&quot;