title: How to customise ordering of results (i.e. something other than alphabetical order for strings)
body: <p>I have a table "Category" in sql server2008. It has 2 columns -ID,Name. I have inserted 3 Name in it as:</p>
  
  <pre><code>1.Case Report
  2.Original Article
  3.Letter to Author
  4.Submmited Article
  </code></pre>
  
  <p>I have used following query to show table data:</p>
  
  <p>select * from Category order by Name desc</p>
  
  <p>it is showing result as:</p>
  
  <pre><code>4.Submmited Article
  2.Original Article
  3.Letter to Author
  1.Case Report
  </code></pre>
  
  <p>But I want to show table value as:</p>
  
  <pre><code>2.Original Article
  1.Case Report
  3.Letter to Author
  4.Submmited Article
  </code></pre>
  
  <p>please help me someone.</p>