ORDER BY when datetime is NULL

[medmed]

Hi all,

i have a table relA with a datetime column ADate. this column can contain a value or NULL. Now, i would like to sort the rows as follow:

SELECT * FROM relA
ORDER BY ADate;

Now, the rows with an NULL date appear on the top. How can I change it to appear rows with NULL date value at the bottom?I don't have a clue anymore...

Many thanks for any hint
Dani

 

[Rhys666]

order by
	isnull(Date_Field, DateAdd(yy, 200, GetDate()))

...or similar

Rhys
The use of COBOL cripples the mind; its teaching should, therefore, be regarded as a criminal offense Edsgar Dijkstra
If life were fair, Dan Quayle would be making a living asking 'Do you want fries with that?' John Cleese

 

[swampBoogie]

order by case when ADate is null then 1 else 0 end,ADate

 

[medmed]

thanks a lot!
hint from swampBoogie worked perfectly

Cheers
Dani