title: Unable to convert varchar to int in sql
body: <p>I am trying to perform a query where I can convert a <code>varchar</code> to <code>INT</code> column in order to perform a calculation, however, I consistently get this error</p>
  <blockquote>
  <p>Conversion failed when converting the varchar value '83640.00' to data type int</p>
  </blockquote>
  <p>When I exclude this value from the query, then it simply shows the same error message with the next value in the table</p>
  <blockquote>
  <p>Conversion failed when converting the varchar value '57800.00' to data type int</p>
  </blockquote>
  <p>The calculation I am trying to perform is simply the column <code>* 100 (Net_Value_NETWR * 100)</code>. <code>Net_Value_NETWR</code> is currently defined as <code>varchar</code> datatype.</p>