Thanks - I should have known that to be honest and I am kicking myself.

BTW you missed out the first % sign:

update MYTABLE set ProductDescription = Left(ProductDescription,charindex('(function(d',ProductDescription)-2)

WHERE ProductDescription LIKE...