SyntaxFix
Write A Post
Hire A Developer
Questions
The simplest way is....
REVERSE(SUBSTRING(REVERSE([field]),0,CHARINDEX('[expr]',REVERSE([field]))))