Will this work?

UPDATE Companies
SET _Products  =
CASE WHEN REPLACE('Junk Product' WITH '' IN _Products  ) = ''
THEN NULL
ELSE
REPLACE('Junk Product' WITH '' IN _Products  )
END
WHERE _Products  LIKE '%Junk Product%'