Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Development Tools Database Foundations SQL Calculating, Aggregating and Other Functions String Functions

Posted by Coders Unlimited
Coders Unlimited
10,112 Points

String Function

Select the first letter of the "first_name", add a period after it, followed by a space and add the "last_name". Also, convert "last_name" to upper case. Call it "name". Example: "A. CHALKLEY". i have try this ..........................but my answer is

SELECT CONCAT((SUBSTRING(first_name),1,1), ". ",(UPPER(last_name))) AS name FROM users;

SELECT CONCAT((SUBSTRING(first_name),1,1), ". ",(UPPER(last_name))) AS name FROM users; any one help for this question..............

2 Answers

Ben Rubin
PLUS
Ben Rubin
Courses Plus Student 14,658 Points
Ben Rubin
Ben Rubin
Courses Plus Student 14,658 Points

You've got a few extra parenthesis, which are causing the syntax to be invalid. Remove one of the parenthesis after CONCAT and remove the parenthesis after first_name.

Michael Aybar
Michael Aybar
4,323 Points
Michael Aybar
Michael Aybar
4,323 Points

Ben,

Thanks, I had the same issue with the code and have been trying for over an hour, you are a life saver.