Solved

Take data from several fields in sql server table and concatinate into one field.

Posted on 2011-03-25
2
257 Views
Last Modified: 2012-08-13
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?
0
Comment
Question by:sannunzi
2 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 500 total points
ID: 35217539
I suspect there may be more to this than you have said so far but anyway..
In Access..

Update   Order_Line_Detail  set   Strip_SI =
Strip_SI &  Recoat_SI &  ReCutDS_SI & Transfer_SI & Specials_SI & Bushing_SI & Replate_SI & Specials_PF_SI

This will update every record in the table.
0
 

Author Closing Comment

by:sannunzi
ID: 35219016
Thanks, didn't realize it would be that straightforward.  You guys are the best!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now