title: What is best way to get last indexof character in SQL 2008
body: <p>In C#, we have <code>String.LastIndexOf</code> 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 <code>CHARINDEX</code> but couldn't able to achieve it.</p>