Hi, I have a field in an SQLServer database, and I need to add a string to the end of the existing content. Is it possible to do this in a single UPDATE query?
I guess it would be possible using a sub-query, such as:
UPDATE table SET column='(SELECT column FROM table WHERE columnID=ID)"&newString&"' WHERE columnID=ID
but Im keen to know if I can do it with a single query...