title: Remove Leading Zeros in a nvarchar column in SQL Server
body: <p>How can I remove all leading zeros from a <code>nvarchar</code> datatype column in SQL Server?</p>
  
  <p>Example:</p>
  
  <pre><code>0000000000245
  0000000001270
  </code></pre>