What is best way to get last indexof character in SQL 2008

Question

In C#, we have String.LastIndexOf method to get a last index of a particular character location for given string. Is there any similar function to do same in SQL Server? I tried using CHARINDEX but couldn't achieve it.

Answer 1

A little tricky, but you could do something like:

REVERSE(SUBSTRING(REVERSE([field]),0,CHARINDEX('[char]',REVERSE([field]))))