Solved

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

Posted on 2011-03-25
2
290 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

752 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