Remove the leading 0(left) character 取得連結 Facebook X Pinterest 以電子郵件傳送 其他應用程式 by Asam 12月 12, 2019 MSSQL SUBSTRING(Id, PATINDEX('%[^0]%', Id), 8000) "WoID" Reference : http://sqlqna.blogspot.com/2014/05/002980298-mssqlpatindexoracletrim.html