Removing leading zeroes from a field in a SQL statement January 1, 2023 by Tarik select substring(ColumnName, patindex('%[^0]%',ColumnName), 10)