Remove substring before last occurrence of a special character in Sql server

Question

I want to remove the substring before last occurrence of period(.). The Query should convert r.k.Lee Brown to Lee Brown. So, basically I need the substring before last dot . and replace it with ''.

Answer 1

Try this:

SELECT RIGHT(@str, CHARINDEX('.', REVERSE(@str)) - 1)

You can slightly modify the above using:

REVERSE('.' + @str))

instead of

REVERSE(@str)

just in case there are no '.' in @str.