title: Remove Leading Zeros in a column in a sql server table,
body: <p>My question is very similar to this one:</p>
  
  <h2><strong><a href="https://stackoverflow.com/questions/92093/removing-leading-zeroes-from-a-field-in-a-sql-statement">SE Question</a></strong></h2>
  
  <p>However I want to run a query on a table, and actually update the values in that table, not just Select them.</p>
  
  <p>Im not sure how to select a value and then Update it without using a for loop.</p>
  
  <p>What Query can I run to do this?</p>
  
  <p>{Edit:}</p>
  
  <p>I store number values as a varchar and an import I ran imported numbers such a 00233
  I want it to be 233</p>