Better techniques for trimming leading zeros in SQL Server? October 20, 2022 by Tarik SUBSTRING(str_col, PATINDEX('%[^0]%', str_col+'.'), LEN(str_col))