title: How to get individual character from varchar columns in SQL?
body: <p>I have a table with this data:</p>
  <pre><code>ID  | Data
  ----+-----
  1   | ABC
  2   | A
  3   | A
  4   | AC
  5   | B
  </code></pre>
  <p>I would like to extract for each row each character and the ID from it come like this:</p>
  <pre><code>ID  | Data_extract
  ----+-----------
  1   | A
  1   | B
  1   | C
  2   | A
  3   | A
  4   | A
  4   | C
  5   | B 
  </code></pre>
  <p>I'm using Microsoft SQL Server</p>
  <p>Thanks</p>