sqlserver 巧用REVERSE和SUBSTRING实现lastindexof

select REVERSE(SUBSTRING(REVERSE(testFixtureNumber),0,CHARINDEX('-',REVERSE(testFixtureNumber)))) from eam_tooling

以上是核心代码，不多说~

【推广】免费学中医，健康全家人

原文地址：https://www.cnblogs.com/caohaifeng/p/5550707.html