SQL Server Queries – Stripping Extra Characters from the End of a String

clive All, Development, SQL, Tech Tip

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 …