misOrz

IT Tech & Life

Remove the leading 0(left) character

MSSQL

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





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