title: want to differ Numeric and alpha value for alphanumeric Column data in Sql
body: <p>I want different value form given example</p>
  
  <p>sample string :</p>
  
  <pre><code>Column1
  ---------
  6A
  6B
  6C
  7A
  7B
  7C
  </code></pre>
  
  <p>Output</p>
  
  <pre><code>Column1   Column2
  ---------------------
  6           A
  6           B
  6           C
  7           A
  7           B
  7           C 
  </code></pre>
  
  <p>Is there any way Please help</p>