title: Sort results alphabetically by name and having column image thats null displayed last
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/2051602/mysql-orderby-a-number-nulls-last">MySQL Orderby a number, Nulls last</a>  </p>
  </blockquote>
  
  
  
  <p>I need to order results in the following way using MS SQL. It needs to order the results by name first alphabetically and then by image name thats not null. And all rows where image is null need to show last and all rows where the image is not null should go first ordered alphabetically by name.</p>
  
  <p>I'm calling the MS Sql query from PHP and it looks similar to this</p>
  
  <pre><code>$sql = "SELECT * FROM products ORDER BY name AsC, image DESC";
  </code></pre>
  
  <p>Is this possible and how?</p>