Treehouse | Community | Concatenating Text

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

Join our Live Career-Building Workshop: Launch Your Tech-Adjacent Career! ⭐ Register here!

🌟 Dreaming of a bright future? 🎓 Ask about the Treehouse Scholarship program! 🚀

Curious which AI tools Treehouse developers love? ⚙️ Check them out!

🫡 Treehouse for Military offers discounts to Veterans, service members and their families!

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Charles Fields
4,205 Points
Has anyone been able to satisfy the question of querying to this format? Andrew Chalkley <andrew@teamtreehouse.com>

Posted December 19, 2019 8:19pm by Charles Fields

Charles Fields
4,205 Points
1 Answer
Jessica Schteiden
3,254 Points
Issue with Concatenation Function

Posted November 16, 2019 4:43am by Jessica Schteiden

Jessica Schteiden
3,254 Points
1 Answer
Duane McAllister
2,858 Points
Am I doing something wrong with how I'm coding

Posted October 25, 2019 8:02pm by Duane McAllister

Duane McAllister
2,858 Points
1 Answer
Jerry Lombardo
945 Points
Concatenation

Posted October 24, 2019 9:12pm by Jerry Lombardo

Jerry Lombardo
945 Points
2 Answers
juannie jimenez
2,859 Points
trying to figure out why my answer is wrong concatenating these columns and Alias it to to_field

Posted October 22, 2019 7:15pm by juannie jimenez

juannie jimenez
2,859 Points
1 Answer
Steve Rogers
3,285 Points
Problem with code

Posted October 21, 2019 9:14pm by Steve Rogers

Steve Rogers
3,285 Points
3 Answers
Shreemangal Sethi
Full Stack JavaScript Techdegree Student 15,552 Points
Please help me with the syntax for this SQL statement.

Posted September 28, 2019 8:28pm by Shreemangal Sethi

Shreemangal Sethi
Full Stack JavaScript Techdegree Student 15,552 Points
2 Answers
Miles Eastwood
1,682 Points
How to concatenate and use an alias at the same time?

Posted September 7, 2019 3:35pm by Miles Eastwood

Miles Eastwood
1,682 Points
1 Answer
sevdiye ozlutas
1,453 Points
What should be the SQL code for challenge one? I have tried different ways but it keeps giving me an error

Posted August 26, 2019 12:52pm by sevdiye ozlutas

sevdiye ozlutas
1,453 Points
3 Answers
Marcus Yang
7,476 Points
I don't know what's wrong with my SQL statement. Pls help!

Posted August 24, 2019 1:57pm by Marcus Yang

Marcus Yang
7,476 Points
2 Answers
Spencer Koss
1,404 Points
Capitalizing One Character in a variable from a Database

Posted August 12, 2019 7:50pm by Spencer Koss

Spencer Koss
1,404 Points
1 Answer
hassan oladini
1,579 Points
Challenge task

Posted August 11, 2019 3:58pm by hassan oladini

hassan oladini
1,579 Points
1 Answer
Cosmin Iuga
2,352 Points
Hello again.

Posted July 27, 2019 1:35pm by Cosmin Iuga

Cosmin Iuga
2,352 Points
3 Answers
Cosmin Iuga
2,352 Points
Hello. Can someone please help? Thank you kindly

Posted July 27, 2019 1:20pm by Cosmin Iuga

Cosmin Iuga
2,352 Points
1 Answer
Cosmin Iuga
2,352 Points
I'm lost here. Here's another version I tried.

Posted July 26, 2019 12:57pm by Cosmin Iuga

Cosmin Iuga
2,352 Points
2 Answers
Cosmin Iuga
2,352 Points
I'm so lost here. :(

Posted July 26, 2019 12:41pm by Cosmin Iuga

Cosmin Iuga
2,352 Points
2 Answers
Shikhar Prateek
1,778 Points
'Your query didn't retrieve the emails in the correct format.' But the query is giving the same result in the workspace.

Posted June 14, 2019 12:23pm by Shikhar Prateek

Shikhar Prateek
1,778 Points
1 Answer
brayden gosse
2,226 Points
In the library database there's a patrons table listing all the users of the library. The columns are id, first_name, la

Posted May 21, 2019 3:10am by brayden gosse

brayden gosse
2,226 Points
2 Answers
Hugo Macfarland
2,030 Points
In the library database there's a patrons table listing all the users of the library. The columns are id, first_name, la

Posted May 19, 2019 4:48pm by Hugo Macfarland

Hugo Macfarland
2,030 Points
1 Answer
Faisal Aleissa
1,992 Points
why id did not work

Posted April 27, 2019 11:14pm by Faisal Aleissa

Faisal Aleissa
1,992 Points
1 Answer
Nelson Pamplona
1,575 Points
I am not sure if I am supposed to include anything but first name, last name and email for this challenge.

Posted April 23, 2019 8:08pm by Nelson Pamplona

Nelson Pamplona
1,575 Points
3 Answers
Apoorva Seeram
790 Points
In the library database there's a patrons table listing all the users of the library. The columns are id, first_name, la

Posted March 28, 2019 8:09pm by Apoorva Seeram

Apoorva Seeram
790 Points
2 Answers
Robert Hecht
6,797 Points
SELECT first_name || " " || last_name || " " || "<" || email || ">" FROM patrons AS 'to_field';

Posted March 20, 2019 2:54pm by Robert Hecht

Robert Hecht
6,797 Points
1 Answer
Namazbek Bekarysuly
882 Points
SELECT first_name || " " || last_name " " || "<" || email || ">" AS "to_field" FROM patrons;

Posted February 22, 2019 11:14pm by Namazbek Bekarysuly

Namazbek Bekarysuly
882 Points
2 Answers
Dan Epstein
3,233 Points
Can anyone assist with how to order the statement in the first SQL Concatenation code challenge? I kind of got lost.

Posted February 14, 2019 10:07am by Dan Epstein

Dan Epstein
3,233 Points
6 Answers
Iman Ali
3,460 Points
ERROR WHEN CONCATENATING WITH A COMMA

Posted February 10, 2019 1:46pm by Iman Ali

Iman Ali
3,460 Points
2 Answers
vishal mishra
387 Points
select CONCAT(first_name , " " ,last_name , " " ,email)AS "to_field" from patrons what is wrong in it

Posted January 26, 2019 2:38pm by vishal mishra

vishal mishra
387 Points
1 Answer
Jeremy Jones
886 Points
Unclear what I am getting wrong...

Posted January 24, 2019 5:19pm by Jeremy Jones

Jeremy Jones
886 Points
2 Answers
Nerijus Velavicius
249 Points
SELECT Street || ", " || " " || City || ", " || " " || State || " " || Zip || "." || " " || Country || " " AS address

Posted January 23, 2019 7:10pm by Nerijus Velavicius

Nerijus Velavicius
249 Points
1 Answer
dfeem
4,660 Points
Stuck on this task?

Posted January 22, 2019 12:38am by dfeem

dfeem
4,660 Points
2 Answers

Prev Page 3 of 5 Next

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