title: Sorting nvarchar column containing alphanumeric values
body: <p>One of my columns in a SQL Server 2005 table contains alphanumeric values and I want to sort the rows as per the alphanumeric sorting. <code>HOUSE_NO</code> is a <code>NVARCHAR</code> column and it contains values like this:</p>
  
  <pre><code> - 2/1 NAWOG
   - 1/1
   - 2/1 A
   - 1/2 A GOLCHA
   - 1
   - 2
   - SHASWAT KUTIR
   - 3 A
   - 11/1
   - 11
  </code></pre>
  
  <p>And I want them to be sorted as: </p>
  
  <pre><code> - 1
   - 1/1
   - 1/2 A GOLCHA
   - 2
   - 2/1 A
   - 2/1  NAWAG
   - 3 A
   - 11
   - 11/1
   - SHASWAT KUTIR
  </code></pre>
  
  <p>I have tried many methods but not successful. I need your suggestions</p>