Null Date Values and order by

#1

How do I order a query by a date field ASC, but have any NULL values
show up last? i.e.

7/1/2003
7/5/2003
7/10/2003
<NULL>
<NULL>

Any help will greatly be appreciated

#2

Dean Mathews (paradigmis (AT) hotmail (DOT) com) writes:

Quote:

How do I order a query by a date field ASC, but have any NULL values
show up last? i.e.

7/1/2003
7/5/2003
7/10/2003
NULL
NULL

ORDER BY colaesce(date, '99991231')

--
Erland Sommarskog, SQL Server MVP, sommar (AT) algonet (DOT) se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

#3

paradigmis (AT) hotmail (DOT) com (Dean Mathews) wrote in message news:<e32dbacc.0307240715.56279933 (AT) posting (DOT) google.com>...

Quote:

How do I order a query by a date field ASC, but have any NULL values
show up last? i.e.

7/1/2003
7/5/2003
7/10/2003
NULL
NULL

Any help will greatly be appreciated

simply use the following in the ORDER BY Clause
select
datefield
from
table
ORDER BY
ISNULL(datefield, '20550101')

(or any other date far larger than the maximum of your resultset)

#4

This works great, thanks for all your help

Dean

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Null Date Values and order by

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Null Date Values and order by - 07-24-2003 , 06:18 PM

Re: Null Date Values and order by - 07-25-2003 , 02:21 AM

Re: Null Date Values and order by - 07-25-2003 , 04:25 AM

Re: Null Date Values and order by - 07-28-2003 , 08:18 AM