I was looking for a method to easily find the last instance of a search string within a longer string.
I found a few instances of ways to do this that involve functions that loop through until no-more instances of the search string are found and some mention of using the SQL 2005+ Reverse function for single character searches.
What wasn't mentioned is that the method of using the Reverse function can be extended/generalized to search for SubStrings of varying lengths.