Posted by Madhivanan on 03/21/06 16:04

declare @s varchar(10)
set @s='as/gf/af/h'
select len(@s)-charindex('/',reverse(@s))+1


Madhivanan

• Next in forum: Re: Job succeeds manually but fails if scheduled
• Prev in forum: Re: Joing tables using more than one field
• Thread view: Re: charindex question

[Reply to this message]