Inserting Data at the end of a field

[cpark87]

I need to insert data into a text field but do not want to overwrite the existing data in this field. I only want to add the new data at the end of the line. The code I currently have to do the insert is listed here

Insert into dbo.Deployment
Set dbo.Deployment.Comments = dbo.NewData.Comments
From dbo.NewData
Where dbo.NewData.MachineID = dbo.NewData.MachineID

Any help would be appreciated

 

[TJRTech]

Use an update statement instead. Assuming you actually have NewData and Deployment table, and that NewData and Deployment are linked through a common MachineID, the following query should work:

update dbo.Deployment
Set dbo.Deployment.Comments = dbo.Deployment.Comments + 
    ' ' + dbo.NewData.Comments
from dbo.Deployment, dbo.NewData    
where dbo.Deployment.MachineID = dbo.NewData.MachineID

TR

 

[cpark87]

That worked thanks....