Treehouse | Community | Replacing Strings

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

🌟 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

Michael Martin
8,653 Points
What is wrong here? I don't understand the output matches against itself

Posted June 15, 2018 4:13am by Michael Martin

Michael Martin
8,653 Points
2 Answers
Hanna Han
4,105 Points
Replace usage

Posted June 13, 2018 3:24pm by Hanna Han

Hanna Han
4,105 Points
2 Answers
Hanna Han
4,105 Points
Does length count in white space in syntax?

Posted June 13, 2018 12:28pm by Hanna Han

Hanna Han
4,105 Points
1 Answer
Hanna Han
4,105 Points
quotes usage for column names when using AS keyword

Posted June 13, 2018 10:21am by Hanna Han

Hanna Han
4,105 Points
1 Answer
Lisa Simpson
33,351 Points
Concatination

Posted June 12, 2018 10:05am by Lisa Simpson

Lisa Simpson
33,351 Points
1 Answer
Michael Martin
8,653 Points
What is wrong with my syntax?

Posted June 12, 2018 3:43am by Michael Martin

Michael Martin
8,653 Points
1 Answer
Michael Martin
8,653 Points
This statement works in SQL Playground, aliasing three values as to_field, what am I doing wrong with this question?

Posted June 12, 2018 3:01am by Michael Martin

Michael Martin
8,653 Points
1 Answer
Deborah Watson
2,614 Points
How do I correctly format the email?

Posted June 10, 2018 6:58pm by Deborah Watson

Deborah Watson
2,614 Points
2 Answers
Odane Williams
6,692 Points
What "format" do they want the email to be in?

Posted June 8, 2018 9:22pm by Odane Williams

Odane Williams
6,692 Points
1 Answer
Felix Bynum
1,129 Points
It says I need brackets around "email" but email is a column. Please help.

Posted June 4, 2018 2:30pm by Felix Bynum

Felix Bynum
1,129 Points
1 Answer
Kimberly Johns
909 Points
Reporting with SQL Challenge Task

Posted May 24, 2018 6:08pm by Kimberly Johns

Kimberly Johns
909 Points
2 Answers
Noel Thurau
1,021 Points
I'm having trouble with 2 of the quizzes.

Posted May 23, 2018 9:57pm by Noel Thurau

Noel Thurau
1,021 Points
1 Answer
Troy Erby
6,332 Points
Having trouble with Reporting SQL with the REPLACE function

Posted May 22, 2018 1:29pm by Troy Erby

Troy Erby
6,332 Points
1 Answer
Edgardo Tupiño
Front End Web Development Techdegree Graduate 32,244 Points
I tried with this query "SELECT SUBSTR(first_name, 1, 1) || " " || last_name AS initial FROM customers;" and return me "

Posted May 22, 2018 2:54am by Edgardo Tupiño

Edgardo Tupiño
Front End Web Development Techdegree Graduate 32,244 Points
2 Answers
John Tester
3,366 Points
SQL Reporting ecommerce challenge; concatenate

Posted May 14, 2018 2:19pm by John Tester

John Tester
3,366 Points
1 Answer
John Tester
3,366 Points
longest length

Posted May 9, 2018 9:41pm by John Tester

John Tester
3,366 Points
2 Answers
John Fujita
1,776 Points
Can you select all (*) but still use functions or alias certain columns without writing them all out?

Posted March 26, 2018 10:02pm by John Fujita

John Fujita
1,776 Points
1 Answer
Giuseppe Ardito
14,130 Points
Replacement functions with multiple conditions

Posted January 11, 2018 12:10am by Giuseppe Ardito

Giuseppe Ardito
14,130 Points
1 Answer
Allen Gonzalez
788 Points
Challenge 1 of the following quiz asks to put <> around the email

Posted November 24, 2017 2:16pm by Allen Gonzalez

Allen Gonzalez
788 Points
1 Answer
Nico Leuchter
9,572 Points
Hello, I ask myself if i put EVERY function in a place where i put a column name or value.

Posted October 4, 2017 9:09am by Nico Leuchter

Nico Leuchter
9,572 Points
1 Answer
PLUS

tonypitkin2
Courses Plus Student 1,950 Points
Can you combine a Substring and Replace function inside one another?

Posted March 22, 2017 12:10am by tonypitkin2

tonypitkin2
Courses Plus Student 1,950 Points
2 Answers
Pamela LaMarca
1,072 Points
Previous exercise - Concatenate text and place <> around email address - your examples and teaching are very unclear.

Posted December 6, 2016 3:47pm by Pamela LaMarca

Pamela LaMarca
1,072 Points
3 Answers
orange sky
Front End Web Development Techdegree Student 4,945 Points
Replace()

Posted October 18, 2016 7:46pm by orange sky

orange sky
Front End Web Development Techdegree Student 4,945 Points
2 Answers
orange sky
Front End Web Development Techdegree Student 4,945 Points
Reporting with SQL LOWER(), and UPPER()

Posted October 18, 2016 7:19pm by orange sky

orange sky
Front End Web Development Techdegree Student 4,945 Points
1 Answer
orange sky
Front End Web Development Techdegree Student 4,945 Points
LOWER()

Posted October 13, 2016 12:26pm by orange sky

orange sky
Front End Web Development Techdegree Student 4,945 Points
2 Answers
Kristian Woods
23,414 Points
I don't understand the SQL REPLACE() function

Posted October 6, 2016 12:48pm by Kristian Woods

Kristian Woods
23,414 Points
7 Answers
Hemen Nabi
15,192 Points
Which one of these functions is more widely used, `substr()` or `mid()`?

Posted October 4, 2016 6:49pm by Hemen Nabi

Hemen Nabi
15,192 Points
1 Answer
kevinloader
6,825 Points
Mistake in the Video

Posted September 6, 2016 3:56pm by kevinloader

kevinloader
6,825 Points
0 Answers
Sebastian Eguez
8,248 Points
Can you explain this string to me?

Posted August 18, 2016 11:33pm by Sebastian Eguez

Sebastian Eguez
8,248 Points
3 Answers
MOD

Jonathan Grieve
Treehouse Moderator 91,253 Points
Final Question of the Playground Practice

Posted March 4, 2016 5:40pm by Jonathan Grieve

Jonathan Grieve
Treehouse Moderator 91,253 Points
20 Answers

Prev Page 9 of 10 Next

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