DECODE and boolean-expression

Hi

how can i use Decode if I want to evaluate an boolean expression? I want to convert an Access-SQL-Statement using IIF:

        IIf (Val > 100, ID, 9999) As ID

How can I check if Val is bigger then 100 with Decode, my pseudo code looks like:

        Decode (Val > 100, true, ID, 9999) As ID

but what's the equivalent for 'true' in PL/SQL?

Mfg,
Alex Received on Tue Jan 24 2006 - 14:22:11 CST