Treehouse | Community | Replacing Strings

You found it first ⚡ 50% off any plan for 6 months, exclusive to new subscribers for a limited time only.

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

✨ Earn college credits in Cybersecurity, JS, HTML, CSS and Python

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

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Jenn Giulietti
4,888 Points
REPLACE SQL

Posted October 30, 2020 8:21pm 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,851 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,851 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
John Richter
2,351 Points
how to replace a single piece of a randomly placed character in a substring.

Posted October 12, 2020 2:42pm by John Richter

John Richter
2,351 Points
2 Answers
Talon Ward
2,495 Points
SELECT REPLACE(email, "@" "<at>") AS "obfuscated_email" FROM customers; What am I missing here?

Posted October 9, 2020 12:00am by Talon Ward

Talon Ward
2,495 Points
1 Answer
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
Monika Biela
3,370 Points
Bummer messages

Posted September 10, 2020 12:24pm by Monika Biela

Monika Biela
3,370 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
Ash Mitchell
6,034 Points
Why do we not use 'SELECT FROM' in this query case?

Posted August 13, 2020 12:31pm by Ash Mitchell

Ash Mitchell
6,034 Points
1 Answer
Adam Hughes
1,259 Points
Getting Max Length with title

Posted August 11, 2020 1:28pm by Adam Hughes

Adam Hughes
1,259 Points
1 Answer
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
Alexander Vasin
7,938 Points
Bummer: Expected results to look like "Andrew CHALKLEY", "MCL1001" not "Andrew CHALKLEY", "MCL1001". Looks like the same

Posted July 17, 2020 4:53pm by Alexander Vasin

Alexander Vasin
7,938 Points
1 Answer
Timmy Welch
1,599 Points
Getting same result as expected but not being allowed past the question.

Posted July 4, 2020 3:27pm by Timmy Welch

Timmy Welch
1,599 Points
1 Answer
Ariadna Rodriguez
6,281 Points
I don't understand where I should SELECT a new column and where I should concatenate the new output

Posted July 4, 2020 9:39am by Ariadna Rodriguez

Ariadna Rodriguez
6,281 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 both columns be a substrings?

Posted July 1, 2020 4:14am by Ariadna Rodriguez

Ariadna Rodriguez
6,281 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
Derek Morse
1,776 Points
What am i missing

Posted May 15, 2020 5:03pm by Derek Morse

Derek Morse
1,776 Points
2 Answers
Derek Morse
1,776 Points
What am I missing

Posted May 15, 2020 4:14pm by Derek Morse

Derek Morse
1,776 Points
2 Answers
Gathoni Alice
803 Points
concatenate and change case of the same string

Posted May 4, 2020 12:48pm by Gathoni Alice

Gathoni Alice
803 Points
2 Answers
bright chibuike
3,245 Points
changing cases of a string

Posted April 26, 2020 11:46am by bright chibuike

bright chibuike
3,245 Points
2 Answers
Aquoinette Blair
3,539 Points
Bummer Error

Posted April 24, 2020 7:50pm by Aquoinette Blair

Aquoinette Blair
3,539 Points
1 Answer
Jay Narain
2,311 Points
In the SQL playground there is the assignment "review attribution". but we do not know how to change the column order?

Posted April 24, 2020 4:58pm by Jay Narain

Jay Narain
2,311 Points
4 Answers

Prev Page 3 of 10 Next

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