select
reverse(substring(reverse(column),charindex(character,reverse(column)),len(column)))
from dbo.text
Never in the field of human conflict was so much owed by so many to so few. All our hearts go out to the developers, whose brilliant actions we see with our own eyes day after day…