title: SQL query to split column data into rows
body: <p>I am having sql table in that I am having 2 fields as <code>No</code> and <code>declaration</code></p>
  
  <pre><code>Code  Declaration
  123   a1-2 nos, a2- 230 nos, a3 - 5nos
  </code></pre>
  
  <p>I need to display the declaration for that code as:</p>
  
  <pre><code>Code  Declaration 
  123   a1 - 2nos 
  123   a2 - 230nos 
  123   a3 - 5nos
  </code></pre>
  
  <p>I need to split the column data to rows for that code.</p>