DECLARE @input_string VARCHAR(100) = '/Opr Rep/Clm R/ABC123_Clm R'

SELECT RIGHT(@input_string, CHARINDEX('/', REVERSE('/' + @input_string)) - 1) AS e_string