How to remove leading 0 in SQL

Remove leading 0 in SQL:

select substring(ColumnName, patindex('%[^0]%',ColumnName), len(ColumnName))