Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2011-03-25
2
Medium Priority
?
306 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 2000 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

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

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

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

927 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