Append more information

[wuwang]

Hi,

I need to add more information in data which has something in there already. How can I "append" the new information in a data?

Very appreciate if you can help me with it.

 

[tlbroadbent]

If by "append" you mean you want to concatenate more data to a char, varchar or text column then you can accomplish that with an Update query.

Update table1 Set colA = ColA + 'the new data to add to the column'
Where <enter you selection criteria>

If the data is in another related table you can Update table1 with data from table2.

Update table1 Set colA = colA + table2.ColX
From table1 Inner Join table2 On table1.ID=table2.ID
Where <enter you selection criteria>

Hope this is helpful. Terry

http://members.home.net/tlbroadbent/prog.htm

_____________________________________
Man's mind stretched to a new idea never goes back to its original dimensions. - Oliver Wendell Holmes