Remove Leading Zero from Column + SQL Server

SELECT SUBSTRING(TempColumn, PATINDEX('%[^0 ]%', TempColumn + ' '), LEN(TempColumn))
FROM TempTable

More Details : http://blog.sqlauthority.com/2012/11/19/sql-server-removing-leading-zeros-from-column-in-table/