Take data from several fields in sql server table and concatinate into one field.
Posted on 2011-03-25
I have 7text fields that I want to concatinate into another text field that already has data in it.
The field names that I want to move the data from are Recoat_SI, ReCutDS_SI, Transfer_SI, Specials_SI, Bushing_SI, Replate_SI and Specials_PF_SI. The field that I want the data added to is called Strip_SI. This field already has data in it, so I don't want the existing data overwritten, just added to. The table name is Order_Line_Detail. What update commands would I use in SQL server or in MS access to make this happen?