title: Splitting comma-separated values in SQL Server (php explode like)
body: <p>I have column called <code>Tags</code> in a table with comma-separated values like  </p>
  
  <pre><code>select 'hot,sweet,wow,cool' as Tags
  </code></pre>
  
  <p>Problem is that I want to explode it with comma and show it like below</p>
  
  <pre><code>Tags
  -----
  hot
  sweet
  wow
  cool
  </code></pre>
  
  <p>Possible?</p>