>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 ?
DECLARE @test varchar(max)
SET @Test = 'This is some sample text and THIS IS THE TEXT I WANT TO REMOVE this is some more random text'
SELECT REPLACE(@Test, 'THIS IS THE TEXT I WANT TO REMOVE','')
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.