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

Jenn Giulietti
4,888 Points
CONCAT SQL

Posted November 1, 2020 7:23pm by Jenn Giulietti

Jenn Giulietti
4,888 Points
1 Answer
Jenn Giulietti
4,888 Points
concatenate SQL

Posted October 30, 2020 7:44pm by Jenn Giulietti

Jenn Giulietti
4,888 Points
2 Answers
Jason Nutt
Front End Web Development Techdegree Graduate 24,760 Points
I really did not want to ask for help on this one as I think I understand the concept...here is the code I tried.

Posted October 26, 2020 4:02pm by Jason Nutt

Jason Nutt
Front End Web Development Techdegree Graduate 24,760 Points
2 Answers
Lyola Rowe
3,806 Points
I'm typing this and getting "incorrect format" error. What am I doing wrong?

Posted October 21, 2020 4:29am by Lyola Rowe

Lyola Rowe
3,806 Points
1 Answer
pashastegall
1,921 Points
Challenge Task 1 of 2 - Can't get beyond it, What have I done wrong??

Posted October 12, 2020 11:24pm by pashastegall

pashastegall
1,921 Points
2 Answers
PLUS

Jordan young
Courses Plus Student 5,277 Points
Alias in Concatenation Reporting

Posted September 16, 2020 3:05am by Jordan young

Jordan young
Courses Plus Student 5,277 Points
1 Answer
Tom Weaver
2,342 Points
I can't get my head around the aliasing here.

Posted September 3, 2020 3:13pm by Tom Weaver

Tom Weaver
2,342 Points
1 Answer
theteamtreehouse
3,472 Points
This test case only supports "operator ||", but it did not specify that it only supports SQLite syntax. I used CONCAT().

Posted August 20, 2020 4:15pm by theteamtreehouse

theteamtreehouse
3,472 Points
0 Answers
Justin Young
7,015 Points
SELECT first_name || " " || last_name || " " || <email> AS "to_field" FROM patrons; [SOLVED]

Posted August 4, 2020 9:20pm by Justin Young

Justin Young
7,015 Points
1 Answer
aditya verma
1,853 Points
Please improve the quality of questions, the period at the end of the text, is it part of the output or not?!

Posted August 2, 2020 11:06am by aditya verma

aditya verma
1,853 Points
2 Answers
aditya verma
1,853 Points
Don't know whats wrong

Posted August 2, 2020 10:58am by aditya verma

aditya verma
1,853 Points
1 Answer
aditya verma
1,853 Points
Cannot identify the mistake

Posted August 2, 2020 10:55am by aditya verma

aditya verma
1,853 Points
1 Answer
Tom Holliday
2,868 Points
I don't understand how we are supposed to know what the correct email formatting is. Are we supposed to add the < signs?

Posted July 1, 2020 1:36pm by Tom Holliday

Tom Holliday
2,868 Points
1 Answer
Ariadna Rodriguez
6,281 Points
Should I be adding a space in between the commas also is that why my query is incorrect?

Posted June 29, 2020 1:03am by Ariadna Rodriguez

Ariadna Rodriguez
6,281 Points
1 Answer
Milind Sharma
2,656 Points
Why am i getting extra . at the end the select statement?

Posted June 17, 2020 4:40pm by Milind Sharma

Milind Sharma
2,656 Points
1 Answer
Stacy Villibord
2,017 Points
Correct my syntax

Posted April 24, 2020 12:16am by Stacy Villibord

Stacy Villibord
2,017 Points
1 Answer
Samantha York
703 Points
I cannot figure out the solution to Challenge Task 1 of 2 under Reporting with SQL: Adding Text Columns Together

Posted April 23, 2020 11:10pm by Samantha York

Samantha York
703 Points
2 Answers
Taylor Han
2,406 Points
Concatenation with an alias

Posted April 16, 2020 11:47pm by Taylor Han

Taylor Han
2,406 Points
1 Answer
vona goodpaster
1,719 Points
need help

Posted April 15, 2020 1:54am by vona goodpaster

vona goodpaster
1,719 Points
2 Answers
pratyush raj
7,097 Points
i am doing everything correct still i am not getting the answer

Posted April 8, 2020 12:40pm by pratyush raj

pratyush raj
7,097 Points
1 Answer
Balazs Ferencz
4,993 Points
Getting a "Your query didn't retrieve the emails in the correct format." error message and I don`t understand why.

Posted April 3, 2020 7:07am by Balazs Ferencz

Balazs Ferencz
4,993 Points
2 Answers
Taylor Han
2,406 Points
SQL concatenation

Posted April 2, 2020 4:17pm by Taylor Han

Taylor Han
2,406 Points
1 Answer
Taylor Han
2,406 Points
SQL concatenation question

Posted April 1, 2020 10:58pm by Taylor Han

Taylor Han
2,406 Points
1 Answer
Tafari Carnegie
2,679 Points
Hi, I believe my code is correct but for some reason, it is saying it isn't. I have done what the question has asked me.

Posted March 19, 2020 2:12am by Tafari Carnegie

Tafari Carnegie
2,679 Points
1 Answer
Caleb Newell
12,562 Points
Help with this SQL query

Posted March 18, 2020 7:43pm by Caleb Newell

Caleb Newell
12,562 Points
1 Answer
Marina Toto
1,479 Points
Im getting the tip of putting angle brackets for an email - but I dont know how to do it

Posted March 9, 2020 7:08pm by Marina Toto

Marina Toto
1,479 Points
2 Answers
Zachary keller
3,178 Points
Cant understand the question, mainly the end part

Posted February 12, 2020 5:41pm by Zachary keller

Zachary keller
3,178 Points
3 Answers
Zachary keller
3,178 Points
The way the question is worded confuses me.

Posted February 11, 2020 8:29pm by Zachary keller

Zachary keller
3,178 Points
2 Answers
Arush Sharma
2,513 Points
I don't understand what is wrong in my query, How should I move to next question or see the solution of this one ?

Posted January 22, 2020 6:08am by Arush Sharma

Arush Sharma
2,513 Points
1 Answer
Mohd Aamir Mir
3,281 Points
where am i wrong in writing this query?

Posted January 11, 2020 11:57am by Mohd Aamir Mir

Mohd Aamir Mir
3,281 Points
2 Answers

Prev Page 2 of 5 Next

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