Condition in SQL

From: <francan00_at_yahoo.com>
Date: Tue, 27 Nov 2007 19:35:41 -0800 (PST)
Message-ID: <b133ed52-4246-4363-92f0-62472dd44353@d27g2000prf.googlegroups.com>

I have this query with a condition in Access and would like to know how I can put a condition part in Oracle 9i SQL similiar to how Access does it?

Current Access SQL that I want to rewrite in Oracle where I just need to know how to do the condtion part: IIF( ISNULL(d.NOTES)=True,'Not Available',d.NOTES) AS NOTES

SELECT

b.FirstName,
b.LastName,
c.FirstName,
c.LastName,
a.Info,

IIF( ISNULL(d.NOTES)=True,'Not Available',d.NOTES) AS NOTES FROM
Person AS b,
Person AS c,
Notes AS d,
Main AS a
WHERE
a.MID= 34
And
b.PID=a.PO
And
c.PID=a.TE
And
d.MID=a.MID Received on Tue Nov 27 2007 - 21:35:41 CST