title: How to convert Varchar to Int in sql server 2008?
body: <p>How to convert Varchar to Int in sql server 2008.</p>
  
  <p>i have following code when i tried to run it wont allowed me to convert Varchar to Int.</p>
  
  <pre><code>Select Cast([Column1] as INT) 
  </code></pre>
  
  <p>Column1 is of Varchar(21) NOT NULL type and i wanted to convert it into Int.
  actually i am trying to insert Column1 into another table having Field as INT.
  can someone please help me to convert this ?</p>