order by date asc putting blank dates on the bottom
Posted on 2006-10-24
I'm doing a query where I want to sort the data by the column "shipdate". The most recent ship dates should be on top. Simple enough using order by date ASC.
Similar to this...
name, dealer, orderid, shipdate
ORDER BY shipdate ASC
HOWEVER, some of the shipdates are null and/or empty. These ship dates are returning on the top of the returned query. I want the rows with no ship date to appear on the BOTTOM of the query, after the rows that have a ship date in the proper order.
How can I do this?