select REVERSE(SUBSTRING(REVERSE(testFixtureNumber),0,CHARINDEX('-',REVERSE(testFixtureNumber)))) from eam_tooling
以上是核心代码,不多说~
转载于:https://www.cnblogs.com/caohaifeng/p/5550707.html
select REVERSE(SUBSTRING(REVERSE(testFixtureNumber),0,CHARINDEX('-',REVERSE(testFixtureNumber)))) from eam_tooling
以上是核心代码,不多说~
转载于:https://www.cnblogs.com/caohaifeng/p/5550707.html