How To Do This In Oracle

With Microsoft Access, to assign a conditional value to a calculated field I use the IIf() function as below:

SELECT Iff([Paid], NULL, [InvoiceAmt])

This is interpreted as: if the Paid field value is true, then make the calculated field value null (blank); otherwise, make the calculated field value the same as the InvoiceAmt field value.

How to do this in oracle? Thanks in advance. Received on Thu Mar 28 2002 - 19:44:09 CST