title: T-SQL Remove Zero Padding as String Manipulation
body: <p>If you are dealing with strings as nvarchar and varchar in SQL Server what is the correct way to drop leading zeros without casting to an INT type?</p>
  
  <p>Say '000123' for example. I would like to convert this into '123'</p>