title: SQL server: concatenating values from two numeric columns
body: <p>I am using SQL Server 2008. I have made a new numeric column called <code>unique_number</code> and I would like to populate this column by concatenating two other numeric columns called <code>site</code> and <code>number</code>.  The <code>site</code> column ranges from 1-31 and the values smaller than 10 do not have a zero in front of them.  I Would like the following</p>
  
  <pre><code>Number      Site   unique_number
  1234567      2       12345672
  3456789      26      345678926
  </code></pre>
  
  <p>Using the <code>+</code> I have been able to get <code>unique_number</code> to be the sum of the two columns, but I want a concatenation to occur, not a summation. I've tried other suggestions using cast as <code>varchar</code>, but the select statement continues to give me errors.  Is there a reasonable way to do this?</p>