Exact solution to the problem. Thanks.

Check following script made little modification.

declare @ToFind varchar(100)

declare @InString varchar(200)

set @ToFind = 'llo'

set @InString = 'Hello World, Hello World'

select LEN(@InString) - (CharIndex(reverse(@ToFind),reverse(@InString)) + (len(@ToFind) -2))