select REVERSE(SUBSTRING(REVERSE(testFixtureNumber),0,CHARINDEX('-',REVERSE(testFixtureNumber)))) from eam_tooling
以上是核心代码,不多说~
sqlserver 巧用REVERSE和SUBSTRING实现lastindexof
最新推荐文章于 2024-09-04 21:49:40 发布

select REVERSE(SUBSTRING(REVERSE(testFixtureNumber),0,CHARINDEX('-',REVERSE(testFixtureNumber)))) from eam_tooling
以上是核心代码,不多说~