Yesterday while implementing a particularly difficult SQL report query, I came across the following question: Given a String ‘This is a test, this is a second test’, is there an easy method (preferably without using CLR) to search and replace the string to remove the word ‘test’ but only if it occurs as the last series of characters in a …