title: Order By Clause for NVARCHAR column in SQL Server
body: <p>I need to make the order by for the <code>nvarchar</code> column. The issue is this that the column doesn't have the same pattern of entry, example of some rows of the column are</p>
  
  <pre><code>12    
  9     
  TEF      
  78F    
  T2R
  </code></pre>
  
  <p>How to sort this column by order By clause? The only relief I have is that this column contains only numeric and alpha numeric characters.</p>