title: How to Show data from a column separated by Character values first and then numeric values in sql server
body: <p>Suppose i have a table </p>
  
  <pre><code>id  Values
  1   A
  2   B
  3   C
  4   7
  5   J
  6   K
  7   L
  </code></pre>
  
  <p>Now i want an output like </p>
  
  <pre><code>id  Values
  1   A
  2   B
  3   C
  4   J
  5   K
  6   L
  7   7
  </code></pre>
  
  <p>How this can be achieved ? </p>