Hi All, I have a requirement to remove a string of text from a SS table column, the field is of type varchar(MAX) and could contain other text apart from the text I need to remove.

"This is some sample text and THIS IS THE TEXT I WANT TO REMOVE this is some more random text"

Is there a way to remove THIS IS THE TEXT I WANT TO REMOVE ?