I am trying to update a database and replace existing text strings. The existing text strings have & within them.
The command I am inputting is
update fieldd0300 set supplier = 'ABBOTT AND COSTELLO' where supplier like 'A & C%';
This then prompts me for a value for C which is not what I want...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.