Treehouse | Community | Getting the Length of a String

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

Laura Dumitru
9,819 Points
DOESNT WORK: SELECT title LENGTH(title) AS longest_length FROM books ORDER BY longest_length DESC LIMIT 1;

Posted July 10, 2024 2:10pm by Laura Dumitru

Laura Dumitru
9,819 Points
1 Answer
Nile Rankin-Watson
1,780 Points
What's wrong with this code? SELECT first_name || " " || last_name || " <" || email || ">" AS "to_field";

Posted June 18, 2024 8:28pm by Nile Rankin-Watson

Nile Rankin-Watson
1,780 Points
1 Answer
Abigail Solomon
4,716 Points
How do you alias the strings you concatenate to "to_field"? And properly concatenate these strings?

Posted May 10, 2024 8:33pm by Abigail Solomon

Abigail Solomon
4,716 Points
2 Answers
Jennifer Sanders
1,747 Points
Help with code, please.

Posted December 13, 2023 7:39pm by Jennifer Sanders

Jennifer Sanders
1,747 Points
1 Answer
Juan Moyar
2,871 Points
Result form Task 1

Posted August 4, 2023 3:42pm by Juan Moyar

Juan Moyar
2,871 Points
2 Answers
Daiana Cherhynets
1,354 Points
SELECT ||(first_name, ' ', last_name, ' <', email, '>') AS to_field FROM patrons

Posted April 30, 2023 10:44pm by Daiana Cherhynets

Daiana Cherhynets
1,354 Points
1 Answer
Alexander Tomashevskiy
8,326 Points
I don't understand where is the mistake? Bummer: Expecting results like 'L Chalkley' not 'L Chalkley'.

Posted April 26, 2023 12:15pm by Alexander Tomashevskiy

Alexander Tomashevskiy
8,326 Points
1 Answer
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
Wufei Hong
1,393 Points
bummer reason

Posted March 24, 2023 6:08am by Wufei Hong

Wufei Hong
1,393 Points
1 Answer
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
Minh Duong
1,616 Points
SELECT CONCAT(first_name, ' ', last_name) AS "To_field", CONCAT('<', email, '>') AS "To" FROM patrons; why is missing?

Posted February 9, 2023 8:43pm by Minh Duong

Minh Duong
1,616 Points
1 Answer
Miroslav Pasajlic
795 Points
Question Expecting results like 'L Chalkley' not 'L Chalkley'

Posted December 23, 2022 6:01pm by Miroslav Pasajlic

Miroslav Pasajlic
795 Points
2 Answers
Miroslav Pasajlic
795 Points
Question Bummer: You're missing the angle brackets around the email address.

Posted December 23, 2022 3:48pm by Miroslav Pasajlic

Miroslav Pasajlic
795 Points
1 Answer
MARSHA OURSO
4,312 Points
SUBSTR

Posted October 10, 2022 2:06pm by MARSHA OURSO

MARSHA OURSO
4,312 Points
1 Answer
Geovani Mejia
Front End Web Development Techdegree Student 7,940 Points
Need help with this SQL query

Posted September 20, 2022 2:41pm by Geovani Mejia

Geovani Mejia
Front End Web Development Techdegree Student 7,940 Points
1 Answer
Olesea Verjbitkaia
2,662 Points
Hello! I can't get through Challenge task "Getting the Length of a String"

Posted April 25, 2022 2:45pm by Olesea Verjbitkaia

Olesea Verjbitkaia
2,662 Points
3 Answers
Katie Martens
1,962 Points
How to get the email formatted correctly?

Posted April 7, 2022 8:24pm by Katie Martens

Katie Martens
1,962 Points
2 Answers
Katie Martens
1,962 Points
How do I get the concatenation symbol on an older PC? I tried the + symbol and the challenge task wouldn't accept it.

Posted April 6, 2022 7:47pm by Katie Martens

Katie Martens
1,962 Points
2 Answers
Hank Boudreau
804 Points
How to omit ellipses in the Truncate Names problem that are less than 10?

Posted January 23, 2022 2:05am by Hank Boudreau

Hank Boudreau
804 Points
1 Answer
chris Gougherty
1,683 Points
Issues understanding what is wrong with my code

Posted January 11, 2022 10:53pm by chris Gougherty

chris Gougherty
1,683 Points
1 Answer
chris Gougherty
1,683 Points
Not understanding what the issue is with my code

Posted January 11, 2022 9:13pm by chris Gougherty

chris Gougherty
1,683 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
James Tecco
4,194 Points
Help with a challenge - LENGTH()

Posted December 31, 2021 12:47am by James Tecco

James Tecco
4,194 Points
1 Answer
Paje Schantz
1,775 Points
add brackets to column name

Posted December 30, 2021 1:50am by Paje Schantz

Paje Schantz
1,775 Points
1 Answer
Ridwan Sahardid
4,296 Points
SELECT street || ", " || city || ", " || state || " " || zip || ". " || country AS address FROM address;

Posted December 18, 2021 10:42am by Ridwan Sahardid

Ridwan Sahardid
4,296 Points
1 Answer
Aleksandra Klipa
1,628 Points
How to give a command for email to show as <email> in concatenation function? Thank you

Posted December 6, 2021 12:41pm by Aleksandra Klipa

Aleksandra Klipa
1,628 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
xczurymqdj
2,289 Points
Im not sure why my code isn't working for me.

Posted November 2, 2021 7:07pm by xczurymqdj

xczurymqdj
2,289 Points
4 Answers

Prev Page 1 of 10 Next

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