Get the String from last occurrence of specific character / text in SQL

Select right(ColumnName, charindex('/', reverse(ColumnName) + '/') - 1) From TableName