Monday, May 22, 2006 5:31 PMok can i append some data to the data inside a column??
Tuesday, May 23, 2006 3:24 AM
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.
Tuesday, May 23, 2006 8:26 AMI work with image type.. is that possible..
and i didnt get the idea upstairs .. sorry
Tuesday, May 23, 2006 11:47 AM
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.