原文:
sqlserver 巧用REVERSE和SUBSTRING实现lastindexof
select REVERSE(SUBSTRING(REVERSE(testFixtureNumber),0,CHARINDEX('-',REVERSE(testFixtureNumber)))) from eam_tooling
以上是核心代码,不多说~