title: Convert or Cast VARCHAR to INT; Update column
body: <p><strong>Disclaimer:</strong> 
  I am still learning SQL so I apologize if my question comes off as amateur-ish or is otherwise a very simple answer. I have no formal training. I am teaching myself.</p>
  
  <p>The title may be a bit confusing, as I'm not entirely sure how to word this for a title.</p>
  
  <p>Basically, I want to convert a column in a table thats currently <code>VARCHAR</code> into an <code>INT</code>. The column contains only numbers formatted as such:</p>
  
  <pre><code>00001
  00005
  02150
  </code></pre>
  
  <p>These are essentially <em>ID's</em> which will be appended to a <code>Name column</code> later for other purposes. If its necessary to do so, I'd also like to know how to convert the end result <code>INT</code> to <code>VARCHAR</code> for the append portion. </p>
  
  <p>Here's what I have right now:</p>
  
  <blockquote>
    <p>SELECT CONVERT(INT, LocNo)</p>
  </blockquote>
  
  <p>It returns the results I expect but I think I need to somehow update the existing <code>LocNo column</code> or otherwise put it in a new column for forward use. </p>
  
  <p>What should I do to achieve this? </p>