title: Combining string with variable in SQL Server
body: <p>I am very new to SQL Server. I want to combine <code>01-JUL-</code> and a variable with a year to get a date and am doing this: </p>
  
  <pre><code>select 
     *, 
     '01-Jan-1900' as from_date_x, 
     '01-JUL-' + from_finyr as to_date_x
  into 
     bbt_item_6_a
  from 
     bbt_item_5_finyrs
  </code></pre>
  
  <p>and am getting the following error:</p>
  
  <blockquote>
    <p>Conversion failed when converting the varchar value '01-JUL-' to data type int. </p>
  </blockquote>
  
  <p>I have tried searching for the answer but cannot get it.</p>
  
  <p>Thanks</p>