How to avoid & popup when SQL query contain '&' letter?

Question

I am writing a migration script where I replaced html encoded values by original values like & will get replaced by &. So my SQL query has & letter but when I execute this query it give me popup for every & to replace that character which is as shown below

After clicking on OK its giving anexpecetd result but actually this popup should not come for every &. What should have to do to avoid this popup?

Answer 1

At the top of your script, add:

set define off;