To remove text in SQL fields

UPDATE [EZTV].[dbo].[Channels] SET IP = REPLACE(CAST(IP AS varchar(MAX)),'&latency=300', '')

FROM [EZTV].[dbo].[Channels]
where IP LIKE '%latency%'
and DisplayName like '%lhr87 shld%'
	and DisplayName like '%SRT%'