Treehouse | Community | Concatenating Text

⚡ CYBER NOVEMBER SALE ⚡ 50% off any plan for 6 months, exclusive to new subscribers.

Join the Treehouse affiliate program and earn 25% recurring commission!

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Nile Rankin-Watson
1,780 Points
What's wrong with this code? SELECT first_name || " " || last_name || " <" || email || ">" AS "to_field";

Posted June 18, 2024 8:28pm by Nile Rankin-Watson

Nile Rankin-Watson
1,780 Points
1 Answer
Abigail Solomon
4,716 Points
How do you alias the strings you concatenate to "to_field"? And properly concatenate these strings?

Posted May 10, 2024 8:33pm by Abigail Solomon

Abigail Solomon
4,716 Points
2 Answers
Jennifer Sanders
1,747 Points
Help with code, please.

Posted December 13, 2023 7:39pm by Jennifer Sanders

Jennifer Sanders
1,747 Points
1 Answer
Juan Moyar
2,871 Points
Result form Task 1

Posted August 4, 2023 3:42pm by Juan Moyar

Juan Moyar
2,871 Points
2 Answers
Daiana Cherhynets
1,354 Points
SELECT ||(first_name, ' ', last_name, ' <', email, '>') AS to_field FROM patrons

Posted April 30, 2023 10:44pm by Daiana Cherhynets

Daiana Cherhynets
1,354 Points
1 Answer
Wufei Hong
1,393 Points
bummer reason

Posted March 24, 2023 6:08am by Wufei Hong

Wufei Hong
1,393 Points
1 Answer
Minh Duong
1,616 Points
SELECT CONCAT(first_name, ' ', last_name) AS "To_field", CONCAT('<', email, '>') AS "To" FROM patrons; why is missing?

Posted February 9, 2023 8:43pm by Minh Duong

Minh Duong
1,616 Points
1 Answer
Miroslav Pasajlic
795 Points
Question Bummer: You're missing the angle brackets around the email address.

Posted December 23, 2022 3:48pm by Miroslav Pasajlic

Miroslav Pasajlic
795 Points
1 Answer
Geovani Mejia
Front End Web Development Techdegree Student 7,940 Points
Need help with this SQL query

Posted September 20, 2022 2:41pm by Geovani Mejia

Geovani Mejia
Front End Web Development Techdegree Student 7,940 Points
1 Answer
Katie Martens
1,962 Points
How to get the email formatted correctly?

Posted April 7, 2022 8:24pm by Katie Martens

Katie Martens
1,962 Points
2 Answers
Katie Martens
1,962 Points
How do I get the concatenation symbol on an older PC? I tried the + symbol and the challenge task wouldn't accept it.

Posted April 6, 2022 7:47pm by Katie Martens

Katie Martens
1,962 Points
2 Answers
chris Gougherty
1,683 Points
Not understanding what the issue is with my code

Posted January 11, 2022 9:13pm by chris Gougherty

chris Gougherty
1,683 Points
1 Answer
Paje Schantz
1,775 Points
add brackets to column name

Posted December 30, 2021 1:50am by Paje Schantz

Paje Schantz
1,775 Points
1 Answer
Ridwan Sahardid
4,296 Points
SELECT street || ", " || city || ", " || state || " " || zip || ". " || country AS address FROM address;

Posted December 18, 2021 10:42am by Ridwan Sahardid

Ridwan Sahardid
4,296 Points
1 Answer
Aleksandra Klipa
1,628 Points
How to give a command for email to show as <email> in concatenation function? Thank you

Posted December 6, 2021 12:41pm by Aleksandra Klipa

Aleksandra Klipa
1,628 Points
1 Answer
shirley fuakye
1,534 Points
Im not sure how to format concatenation operators

Posted November 1, 2021 11:18pm by shirley fuakye

shirley fuakye
1,534 Points
1 Answer
xczurymqdj
2,289 Points
im not sure what im doing wrong with my code, can someone please tell me what im doing wrong

Posted November 1, 2021 6:40pm by xczurymqdj

xczurymqdj
2,289 Points
4 Answers
xczurymqdj
2,289 Points
Can i get some help on this quistion that im having trouble with?

Posted October 30, 2021 7:40pm by xczurymqdj

xczurymqdj
2,289 Points
1 Answer
Michelle Ward
732 Points
I am stuck on task 1 of 2 in the concatenating lesson.

Posted October 27, 2021 5:36am by Michelle Ward

Michelle Ward
732 Points
1 Answer
Jose Testa
2,051 Points
Selecting a column so that all the rows would appear between <> operators.

Posted October 12, 2021 1:38pm by Jose Testa

Jose Testa
2,051 Points
2 Answers
Fahad Ahsan
2,595 Points
Stuck on challenge 2 I have this so far

Posted September 7, 2021 5:56pm by Fahad Ahsan

Fahad Ahsan
2,595 Points
1 Answer
clarence hollins
2,301 Points
what do they mean by missing angle brackets.

Posted June 19, 2021 10:53am by clarence hollins

clarence hollins
2,301 Points
1 Answer
Jessica Malady
11,895 Points
How do I get angle brackets around the email address

Posted June 7, 2021 4:29pm by Jessica Malady

Jessica Malady
11,895 Points
1 Answer
PLUS

Jack Chaffin
Courses Plus Student 4,462 Points
I'm on Challenge Task 1 of 2 on Reporting with SQL. Why won't it pass?

Posted April 9, 2021 4:41pm by Jack Chaffin

Jack Chaffin
Courses Plus Student 4,462 Points
1 Answer
Charity Thomas
Front End Web Development Techdegree Student 6,881 Points
Hello. I am stuck on this challenge. Can you please help? Thanks!

Posted February 20, 2021 4:39pm by Charity Thomas

Charity Thomas
Front End Web Development Techdegree Student 6,881 Points
1 Answer
Kathuri k
586 Points
syntax looks ok but throwing error

Posted January 25, 2021 8:03pm by Kathuri k

Kathuri k
586 Points
1 Answer
Cole Vance
882 Points
How does my query need to be adjusted?

Posted November 22, 2020 10:35pm by Cole Vance

Cole Vance
882 Points
1 Answer
Van Nguyen
3,533 Points
Where can I put the angle bracket around the email?

Posted November 20, 2020 4:27pm by Van Nguyen

Van Nguyen
3,533 Points
1 Answer
Mehdi Datoo
2,378 Points
Stuck on this question! Please provide solution!

Posted November 14, 2020 7:40pm by Mehdi Datoo

Mehdi Datoo
2,378 Points
2 Answers
Louis Worth
4,286 Points
Reporting with SQL. Challenge task 1 of 2. am being told that my query didnt return emails in the correct format but why

Posted November 10, 2020 7:40pm by Louis Worth

Louis Worth
4,286 Points
1 Answer

Prev Page 1 of 5 Next

Posting to the forum is only allowed for members with active accounts.
Please sign in or sign up to post.