title: How do I use the CONCAT function in SQL Server 2008 R2?
body: <p>I was looking for a <code>CONCAT</code> function in SQL Server 2008 R2. I <a href="http://msdn.microsoft.com/en-us/library/hh231515.aspx">found the link  for this function</a>. But when I use this function, it gives the following error:</p>
  
  <blockquote>
    <p>Msg 195, Level 15, State 10, Line 7<br>
    'CONCAT' is not a recognized built-in function name.</p>
  </blockquote>
  
  <p>Does the <code>CONCAT</code> function exists in SQL Server 2008 R2?</p>
  
  <p>If not, how do I concatenate strings in SQL Server 2008 R2?</p>