How to get last date only once all have been filled in

I want to be able to return the last date, e.g.

(select Max(DateColumn) From Table)

However if any of the DateColumn fields are null I want to return a
null, is there a simple way to do this?Trevor Best (googlegroups@.besty.org.uk) writes:

Quote:

Originally Posted by

I want to be able to return the last date, e.g.
>
(select Max(DateColumn) From Table)
>
However if any of the DateColumn fields are null I want to return a
null, is there a simple way to do this?

SELECT CASE WHEN EXISTS (SELECT * FROM tbl WHERE DateColumn IS NULL)
THEN NULL
ELSE MAX(DateColumn)
FROM tbl

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||thanks