Re: SELECT MAX question

Jacob wrote:

> I have an sql tatement in my ASP page that has a WHERE date = (SELECT
> MAX(other_date) FROM SomeTable WHERE Blah1 = Blah2) clause. What's
> happening is that the query is grabbing the latest date ONLY if something
> something is in the "other_date" field. If the "other_date" field is blank,
> then the record is not chosen. My question is, how do I grab the latest
> date of "other_date" even if the it happens to be blank?

Adding my own question to this, does pgsql have an equivalent to the
Oracle NVL function?

--
_
/ \ Leandro Guimarães Faria Corsetti Dutra +55 (11) 3040 8913
\ / Amdocs at Bell Canada +1 (514) 786 87 47
X Support Center, São Paulo, Brazil mailto:adbaamd(at)bell(dot)ca
/ \ http://terravista.pt./Enseada/1989/ mailto:leandrod(at)amdocs(dot)com