SQL Server Helper - String Functions - Trim Leading Zeros

Trim Leading Zeros Function One requirement that I was recently asked to do was to remove or trim the leading zeros in an alphanumeric column. The first thing that came to mind was to convert the VARCHAR column into an integer data type column then conver

www.sql-server-helper.com