title: Concatenating Int columns
body: <p>I have a table called Field_Data and the data in the table looks like:</p>
  
  <pre><code>Date                          Track_ID          Item#
  2011-02-25 00:00:00.000       70212             1
  2011-02-25 00:00:00.000       70212             2
  2011-03-09 00:00:00.000       70852             1
  2011-03-09 00:00:00.000       70852             3
  </code></pre>
  
  <p>I am trying to get output as:</p>
  
  <pre><code>Date                          Final_ID
  2011-02-25 00:00:00.000       70212_1
  2011-02-25 00:00:00.000       70212_2
  2011-03-09 00:00:00.000       70852_1
  2011-03-09 00:00:00.000       70852_3
  </code></pre>
  
  <p>I tried doing something like this:</p>
  
  <pre><code>Select Date,Track_ID + '_' + Item# AS Final_ID
  From Field_Data
  </code></pre>
  
  <p>But it gave me following error:</p>
  
  <blockquote>
    <p>Msg 245, Level 16, State 1, Line 1<br>
    Conversion failed when converting the varchar value '_' to data type int.</p>
  </blockquote>
  
  <p>Can anyone help me on how to do this?</p>