I have a varchar(1000) column with data that I need to append to a text column in the same table. How do I do it?
I have tried
SET Comments = Comments + ' - ' + Web
but that gives me the 'invalid operator for data type' error. I tried ampersands as well.