How can I return the charindex of the last occurance of '/' in the
string?
Regards,
Ciarndeclare @.s varchar(10)
set @.s='as/gf/af/h'
select len(@.s)-charindex('/',reverse(@.s))+1
Madhivanan
How can I return the charindex of the last occurance of '/' in the
string?
Regards,
Ciarndeclare @.s varchar(10)
set @.s='as/gf/af/h'
select len(@.s)-charindex('/',reverse(@.s))+1
Madhivanan
Char and Varchar
No comments:
Post a Comment