HomeworkLib
Question

I have data that looks like this: SerenaFrancois SteveLarson AdamMurphy I need help using CONCATENATE function...

I have data that looks like this:

SerenaFrancois

SteveLarson

AdamMurphy

I need help using CONCATENATE function of SQL to separate the names so they look like this:

Serena Francois

Steve Larson

Adam Murphy

This is SQL help.

engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Answer:

Select Concat(FirstName, ' ' ,LastName) from TableName;
Replace the table name with the exact table name and it will work perfectly.

Let me know in case if you have any questions. Thanks and All the best.

0 0
Add a comment
Know the answer?
Add Answer to:
I have data that looks like this: SerenaFrancois SteveLarson AdamMurphy I need help using CONCATENATE function...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Need help!!! I need two programs that use one common database.. One program using a Visual...

    Need help!!! I need two programs that use one common database.. One program using a Visual Basic windows form using textboxes for data input (first name, last name, phone, email) and it should save the info into an SQL database when a save button is clicked. Second program using a C# windows form that has a drop down menu with all the names that have been saved into the database, when one name is clicked all their information should pop...

  • Use the provided toolbar (RCE - Rich Content Editor) here with the "Table" function (looks like...

    Use the provided toolbar (RCE - Rich Content Editor) here with the "Table" function (looks like the window lattice) to draw the table identical to the one shown in this question to type in your responses. Copy the formulas of the given ions in the headings and include them in your table. I need your responses with the names of the resulting compounds. Complete the following table by writing the names for the resulting compounds. Spelling counts. F- S2- PO^3-4...

  • I have a table that looks like this. 1234 5678 9101112 I need to use this...

    I have a table that looks like this. 1234 5678 9101112 I need to use this code public class Lab8 { public static void main(String argv[]) { int ar[][] = new int[3][4]; int n = 1; for (int i=0; i < ar.length; i++) { for (int j=0; j< ar[i].length; j++) { ar[i][j] = n; n++; } } // print out the elements of the array // left to right, top to bottom for (int i=0; i < ar.length; i++) {...

  • #Python I have a data frame called data_tweets, there is one column calls timestamp, the dataset looks like: 2016-06-25...

    #Python I have a data frame called data_tweets, there is one column calls timestamp, the dataset looks like: 2016-06-25 23:59:52 And there is another data frame called data_BTUSD, the time column looks like:27/5/19 0:00 How can I make these two datafram's time in the same format and draw the time line for them? Thanks!

  • QUESTION 12 0.5 points Save Answer Plot the data below and determine what kind of function best fits the data. Then using the form you found, linearize the data so that when plotted it looks Like a l...

    QUESTION 12 0.5 points Save Answer Plot the data below and determine what kind of function best fits the data. Then using the form you found, linearize the data so that when plotted it looks Like a line. What is the slope of this line? 0.5 1138901 1 1511582 15 1836257 2 2.119999 25 2.33711 3 253949 35 27235 4 2.973173 45 3.115939 5 3.241527 55 3.51499 6 3.645197 65 3797634 QUESTION 12 0.5 points Save Answer Plot the data...

  • Java code to read from .csv file i currently have a .csv file that looks like...

    Java code to read from .csv file i currently have a .csv file that looks like this: 39.743222, -105.006241, Hospital 39.743981, -105.020017, Home 39.739377, -104.984774, Firehouse 39.627779, -104.839291, McDonald's 39.731919, -104.961814, Chipotle I need to write code to extract the doubles from each line to use for my Linked List. this is what i have so far: Scanner in = new Scanner(new FileInputStream(DATA_FILE));

  • If I have a long string that looks like this: <div class="rn"> <p> Hello< p> <p>...

    If I have a long string that looks like this: <div class="rn"> <p> Hello< p> <p> Sammy <p> </div><div class="rn"><p> Hi <p> </div> How can I make a list of list in python that would look like this [ [Hello, Sammy] [Hi] ] essentally grabbing what inbetween the <div> <div> and if that <div> has mutiple <p>, extend the list

  • I need to know what the unknown compound is and what the structure looks like based...

    I need to know what the unknown compound is and what the structure looks like based off this H-NMR chart, IR peak and Molecular Formula. Can you please draw the structure out so I can see it. I also want to see how the peaks on the H-NMR relate to the compound you have drawn (like which peak goes to what point on the compond).Hint something that would be leaking out of an oil sands talings pond, also the molecule...

  • Hi I need some help with this I just need the code and the collection name...

    Hi I need some help with this I just need the code and the collection name is research only the code I dont need any screenshots of the output. it should be for companies.json using the research collection as like this db.research.aggregate({}) but I don't know how to do the rest. This is the database but it is hard to paste it all so I will paste some and it should be create. Please I need this to be done...

  • I need help with this lab tions. Let's review a few resources that will help you...

    I need help with this lab tions. Let's review a few resources that will help you prepare for this assignment: What Column Chromatography Looks Like (video) of Column Chromatography (article) . Information on Solvents (web resource) . Pictures of What a Column Looks Like and How It Is Setup (article) A video of .A Column Being Run (video) . Note that the first 4 minutes simply show how the column is prepared. That is not one of your variables. You...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT