>>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','')
>

Thanks Borislav, fastest answer ever ???