Databases Reporting with SQL Working with Text Concatenating Text

Marcus Yang
Marcus Yang
4,613 Points

I don't know what's wrong with my SQL statement. Pls help!

In the library database there's a patrons table listing all the users of the library. The columns are id, first_name, last_name, address, email, library_id and zip_code.

Generate a list of strings that are in the following format: Andrew Chalkley andrew@teamtreehouse.com. Concatenate the first name, last name and email address for all users.

Alias it to to_field. This will be used in the "To" field in email marketing.

SELECT first_name || " " || last_name || " " || email AS "To_field" FROM patrons;

2 Answers

Luke Maslany
Luke Maslany
3,533 Points

You’re close. Try:

select (first_name || ' ' || last_name || ' <' || email || '>') as to_field from patrons

Tommy Gebru
Tommy Gebru
28,819 Points

This one stumped me a few times as well Marcus

I went ahead and formatted it be easier to read

SELECT first_name || " " ||  last_name || " " ||  "<"  || email || ">" 
AS to_field
FROM patrons;

Also Luke is right in using parentheses, much cleaner to group the concatenated parameters :thumbsup: