急求一获取特殊段字符的写法。。

Question

declare @aa varchar(60)
select @aa ='15http:/22.kf.com/5/0.p33.wma171'
select reverse(left(reverse(@aa), charindex('/', reverse(@aa))-1))

Answer 1

declare @aa varchar(60)
select @aa ='15http:/22.kf.com/5/0.p33.wma171'select right(@aa,charindex('/',reverse(@aa))-1)

Answer 2

declare @lastipto varchar(60)
select @lastipto ='15http:/22.kf.com/5/0.p33.wma171'select right(@lastipto,charindex('/',reverse(@lastipto))-1)

Answer 3

declare @aa varchar(60)
select @aa ='15http:/22.kf.com/5/0.p33.wma171'print RIGHT(@aa,charindex('/',REVERSE(@aa))-1)