Remove the leading 0(left) character

MSSQL

SUBSTRING(Id, PATINDEX('%[^0]%', Id), 8000) "WoID"

Reference : http://sqlqna.blogspot.com/2014/05/002980298-mssqlpatindexoracletrim.html