title: SQL Server 2008 Express CONCAT() doesn't exist?
body: <p>I'm making switch from MySQL to SQL Server 2008 Express and can't seem to find a CONCAT()-esque function.  I have two columns I'm trying to combine into a string and find unique combinations.</p>
  
  <pre><code>id1          id2
  001          abc1
  002          qrs5
  003          qrs5
  003          abc1
  ...           ...
  </code></pre>
  
  <p>When I try the following:</p>
  
  <pre><code>  select id1, id2, concat(id1,  ", ", id2) as combo1
    FROM db1
    group by combo1
  </code></pre>
  
  <p>I get the following error message:</p>
  
  <blockquote>
    <p>Msg 195, Level 15, State 10, Line 1<br>
    'concat' is not a recognized built-in function name.</p>
  </blockquote>
  
  <p>Any suggestions?</p>