append data to a coulmn

Question

ok can i append some data to the data inside a column??

Answer 1

 

It will all depend on what the data is in the column and the format off it. For standard text (varchar) you could try this.

update members set MessageText = (select 'Hi ' + name_first + ' ' + name_last + ', Welcome Back')

With the above statement it takes the members first and last names from the field in the database and creates the message text from that. I use the above statement in a cursor, but you should be able to get the idea.

Answer 2

I work with image type.. is that possible..

and i didnt get the idea upstairs .. sorry

Answer 3

 

I haven't done much with the image type but it is binary, you would have to load it all to the client then add the data then send it back to the database in one hit.