Skip to content
Advertisement

How to avoid & popup when SQL query contain ‘&’ letter?

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

enter image description here

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?

Advertisement

Answer

At the top of your script, add:

set define off;
User contributions licensed under: CC BY-SA
8 People found this is helpful
Advertisement