Order by + Case

[vlitim]

I am using the below query to order by date so if there is no date they are grouped together

SQL="SELECT *, orderbyWhat = CASE dueDate WHEN Null THEN 3 WHEN '' THEN 2 ELSE 1 END FROM todoList WHERE staffID="&session("staffID&quot&" AND (DateAdd(hh,12,completeDate) >= getDate() OR completeDate is null) ORDER by orderbyWhat"

bu what I get is

30 Sep 03
(Null)
07 Oct 03

Whereas what I would like is:

30 Sep 03
07 Oct 03

(Null)

what am I doing wrong??
Cheers
Tim

 

[Craigii]

Why use the case? I would just do this:

SQL="SELECT * FROM todoList WHERE staffID="&session("staffID&quot&" AND (DateAdd(hh,12,completeDate) >= getDate() OR completeDate is null) ORDER by orderbyWhat"

Hope It Helps

 

[vlitim]

because it put the null values first wheras i want it to display

30 Sep 03
07 Oct 03
Null