Hi all,

does any one know if there is a equivalent function for Oracle's
DECODE() in DB2?

much thanks
ME

Hi,

Please read Must Read before posting thread for tips how to write efficient post.

One of the tips from above link is:
"3) If your question is regarding the db2 equivalent of a feature in another database, please explain what that feature is all about (rather than saying, 'what is the db2 equivalent of oracle's INSTR' explain in a sentence or two what oracle's INSTR function is and ask how to do that in db2)"

Hope this helps,
Grofaty

You could also try searching this forum as this question has been answered before.