title: ORDER BY DATE showing NULLS first then most recent dates
body: <p>I have a stored procedure which executes a select statement. I would like my results ordered by a date field and display all records with NULL dates first and then the most recent dates.</p>
  
  <p>The statement looks like this:</p>
  
  <pre><code>SELECT a,b,c,[Submission Date]
  FROM someView
  ORDER BY [Submission Date] ASC
  </code></pre>
  
  <p>Now this will display all records with NULL Submission Dates first, but when I get to rows that have date values in them, they are not the most recent dates in the view.</p>
  
  <p>If I replace ASC with DESC, then I get the dates in the the order I want, but the NULL values are at the bottom of my result set.</p>
  
  <p>Is there any way to structure my query so that I can display the null values at the top and then when there are date values, to order them descending most recent to oldest?</p>