DECODE is fine, but where is the IIF ?

Beginner's question:

I just learned about the DECODE function. Very good, but what I am missing is a way to not compare against certain values, but instead being able to code a boolean condition (something like an IIF an Visual Basic). For example the following:

   DECODE(x<y, TRUE, 'less', FALSE, 'greater')

isn't possible. Or is it somehow?

Michael G. Schneider

mgs_software_at_compuserve.com Received on Mon Nov 03 1997 - 00:00:00 CST