Your fr_reverse_charIndex function can be rewritten as:

alter function [dbo].[fn_reverse_charIndex]

/*********************************************************/

/* CREATE fn_reverse_charIndex ...