title: Removing field that I concatenated to break my group by clause and show unique values
body: <p>This is going to be an easy one for you. </p>
  
  <p>I have used Union to join two table and, therefore I am using a group by clause.</p>
  
  <p>I have to values that are exactly the same in every way other than the fact they need to display as separate lines.</p>
  
  <p>this is my column:</p>
  
  <p><code>(select (concat(productiondetail.detailid, ProductionDetail.Description)) as [Description]</code>,</p>
  
  <p>and that result gives me:</p>
  
  <pre><code>SM1250  | 11078Metabisulphite - 1250KG Bags | $ | 500.00
  
  SM1250  | 11079Metabisulphite - 1250KG Bags | $ | 500.00
  </code></pre>
  
  <p>Now I want to remove the numbers in the Description.</p>
  
  <p>Note: the Numbers are sequential and the Descriptions are of various lengths.</p>