Treehouse | Community | Changing Cases of Strings

Notice: Workspaces are undergoing maintenance and are temporarily unavailable.

🚀 In our NEW AI Bootcamp you'll build a working app in 28 days, no experience required. Free to all subscription levels.

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

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

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

PLUS

zaal rottunda
Courses Plus Student 2,434 Points
IN a library database....

Posted April 24, 2023 4:23pm by zaal rottunda

zaal rottunda
Courses Plus Student 2,434 Points
4 Answers
Krithika Pirahalathan
150 Points
alias the query

Posted March 8, 2023 1:25pm by Krithika Pirahalathan

Krithika Pirahalathan
150 Points
1 Answer
Alberto Gurrola
1,769 Points
Hi, I'm not too sure what I'm doing wrong. I tried entering this code but it's still wrong.

Posted February 22, 2023 2:36pm by Alberto Gurrola

Alberto Gurrola
1,769 Points
1 Answer
Paje Schantz
1,775 Points
Not sure what this is looking for

Posted December 31, 2021 1:19am by Paje Schantz

Paje Schantz
1,775 Points
1 Answer
xczurymqdj
2,289 Points
Code is not work still can some please help me?

Posted November 11, 2021 1:05am by xczurymqdj

xczurymqdj
2,289 Points
1 Answer
xczurymqdj
2,289 Points
im haveing some issues with my code. can i get someones help.

Posted November 5, 2021 5:30pm by xczurymqdj

xczurymqdj
2,289 Points
1 Answer
Adam Meikle
6,663 Points
Expected results match actual results yet getting error code, any tips?

Posted November 4, 2020 5:29pm by Adam Meikle

Adam Meikle
6,663 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
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
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
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
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
Taylor Han
2,406 Points
Casing strings with SQL

Posted April 15, 2020 7:58pm by Taylor Han

Taylor Han
2,406 Points
1 Answer
Caleb Newell
12,562 Points
sql as tables

Posted March 27, 2020 12:03pm by Caleb Newell

Caleb Newell
12,562 Points
1 Answer
Claire Brehm
9,098 Points
Having trouble getting the correct answer for task 2 here in the changing cases of strings task

Posted February 26, 2020 10:35pm by Claire Brehm

Claire Brehm
9,098 Points
0 Answers
Diadie Camara
1,842 Points
select first_name|| " " || UPPER(last_name) AS Full_name, library_id from patrons

Posted February 25, 2020 9:36pm by Diadie Camara

Diadie Camara
1,842 Points
2 Answers
Maryam Naz
3,636 Points
how to combine "AS" statement so I wont have to re-type AS each time?

Posted December 31, 2019 12:51am by Maryam Naz

Maryam Naz
3,636 Points
1 Answer
Orchid Li
2,024 Points
In the library database there's a patrons table with the columns id, first_name, last_name, address, email, library_id,

Posted October 7, 2019 7:02pm by Orchid Li

Orchid Li
2,024 Points
2 Answers
David Wells
13,270 Points
In the second question of the library/full name question, how do I write the concatenation SQL statement?

Posted March 19, 2019 5:54pm by David Wells

David Wells
13,270 Points
2 Answers
PLUS

ct7
Courses Plus Student 964 Points
Challenge 1 of 2 - Upper/ Lower

Posted November 27, 2018 11:40pm by ct7

ct7
Courses Plus Student 964 Points
1 Answer
Rhea Khanna
2,838 Points
Complex formula please help

Posted October 19, 2018 12:26pm by Rhea Khanna

Rhea Khanna
2,838 Points
1 Answer
Shain Jones
1,315 Points
Reporting with SQL

Posted October 17, 2018 5:34pm by Shain Jones

Shain Jones
1,315 Points
1 Answer
Jamie Sims
4,317 Points
I'm not sure how I should treat my SQL Statement.

Posted October 9, 2018 6:03pm by Jamie Sims

Jamie Sims
4,317 Points
1 Answer
Brian Ross
11,209 Points
Getting a weird error: Expected results to look like "Andrew CHALKLEY", "MCL1001" not "Andrew CHALKLEY", "MCL1001".

Posted August 26, 2018 11:04pm by Brian Ross

Brian Ross
11,209 Points
5 Answers
Christopher Parke
21,978 Points
No error, but error?

Posted June 18, 2018 5:04pm by Christopher Parke

Christopher Parke
21,978 Points
3 Answers
Kimberly Johns
909 Points
Reporting with SQL Challenge Task

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

Kimberly Johns
909 Points
2 Answers

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