在MS-SQL中,要实现类似lastindex这样的功能可以用reverse和left组合起来达到,先reverse然后left截取再进行reverse
with a as(
select 'Kronos,Capgmini,Akamai,Starbucks' as groupname
)
--get Starbucks
select reverse(left(reverse(groupname),charindex(',',reverse(groupname))-1)) from a