title: Why is SQL converting Varchar value to Integer in a varchar column?
body: <p>I am receiving an error </p>
  
  <blockquote>
    <p>Conversion failed when converting the varchar value to data type int</p>
  </blockquote>
  
  <p>while trying to insert data from one table into another. Both have the same table structure (table being inserted is an exact copy of the one used in the <code>Select</code>) and data types on the columns are the same. </p>
  
  <pre><code>INSERT INTO PS_PSOPRDEFN_BA
      SELECT * 
      FROM PSOPRDEFN
  </code></pre>
  
  <p>Error:</p>
  
  <blockquote>
    <p>Conversion failed when converting the varchar value '11000_600' to data type int.</p>
  </blockquote>
  
  <p>The column this is inserting with this value is a <code>varchar(30)</code> in both tables, so I don't know why SQL is trying to convert it to <code>int</code>. Any ideas are appreciated.</p>