title: Sort Order in SQL Server
body: <p>Can I change the default sort order in a SQL server database so that nulls and zero length strings are displayed last. </p>
  
  <p>Its SQL Server 2000</p>
  
  <p>I stress, I want to change the <em>default</em> order for all queries, if possible</p>