Can DECODE or CASE check two conditions or expressions at the same time? In other words, I want to check if (level is 'CP' AND subject is 'MATH'), then return 'Y', otherwise return 'N'. I have a DECODE statement now that checks if level is 'CP', but I need to add in the subject also. Can I do this with DECODE or CASE or should I be looking at something else? Thanks for any suggestions.