declare @col varchar(255)
set @col='101504/其他货币资金/银行汇票'
select reverse(substring(reverse(@col),0,charindex('/',reverse(@col))))
根据特定字符查找想要字符
最新推荐文章于 2023-07-23 15:58:54 发布
declare @col varchar(255)
set @col='101504/其他货币资金/银行汇票'
select reverse(substring(reverse(@col),0,charindex('/',reverse(@col))))