title: Convert number stored as text data type to int
body: <p>I have a database that is a result of an import.  The database is a deliverable, I did not do the import myself, nor do I have access to the original data to do it myself.  That being said, there is an integer value that was imported to a text datatype.  All of the stored values are valid integers.  I keep getting:</p>
  
  <pre><code>Explicit conversion from data type text to int is not allowed.
  </code></pre>
  
  <p>if I try to change the field data type in the table.  I have also created a new INT field in the table and tried to update it based upon the value in the TEXT field, but I receive the same error.  Lastly I tried to create a new table and tried to insert the old values but cannot convert or cast to the int successfully.</p>