title: SQL SELECT multiple columns into one
body: <p>I have this query in SQL Server 2008:</p>
  
  <pre><code>SELECT Id, Year, Manufacturer, Model  
  FROM Table
  </code></pre>
  
  <p>and I need something like this...</p>
  
  <pre><code>SELECT Id, (Year + [space] + Manufacturer + [space] + Model) AS MyColumn 
  FROM Table
  </code></pre>
  
  <p>How can I get this result?</p>