title: SQL Query - Multiple columns into one column
body: <p>I've had a hunt round here and google and been un able to find anything.</p>
  
  <p>I did come accross the CONCAT function, but as my company runs SQL Server 2008 thats not an option :(</p>
  
  <p>I have a query that outputs multiple columns / rows and I want to disply the results all in one column. </p>
  
  <p>Example:</p>
  
  <pre><code>SELECT client, owner, payer, status
  FROM Main
  WHERE status = 'Active'
  </code></pre>
  
  <p>Result:</p>
  
  <pre><code>client | owner | payer | status
  
  1      |  2    |  3    | Active
  10     |  11   | 12    | Active
  </code></pre>
  
  <p>What I Want it to look like</p>
  
  <pre><code>ColumnX  |
  1
  2
  3 
  Active
  10
  11
  12
  Active
  </code></pre>
  
  <p>Thanks in advance for your help and I hope that makes sense :)</p>
  
  <p>Cheers,
  Michael</p>