Re: SELECT MAX question

>> 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?

You might try adding an additional "OR if Blah1 IS NULL" to your WHERE
clause to pickup the NULL values. This is the way SQL is SUPPOSED to handle
NULL values

len