title: SQL Server split by comma
body: <p>I have a question about splitting column values in T-SQL.
  I have </p>
  
  <pre><code>Address_col
  
  Nevada,USA
  Tokyo,Japan
  Hanoi,Vietnam
  </code></pre>
  
  <p>I want to split the values by comma to </p>
  
  <pre><code>Address_col     Country
  
  Navada          USA
  Tokyo           Japan
  Hanoi           Vietnam
  </code></pre>
  
  <p>How can I do that?</p>