Databases Reporting with SQL Working with Text Concatenating Text

Bryan Makle
Bryan Makle
4,531 Points

How do I add angle brackets at the beginning and end of the email? Please assist

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.

2 Answers

Steven Parker
Steven Parker
158,747 Points

Concatenation can occur between fields, or a combination of fields and literal strings.

For example:

SELECT 'The email is <' || email || '>' AS info FROM sometable;

This would return rows that look like :point_right: The email is <andrew@teamtreehouse.com>

Bryan Makle
Bryan Makle
4,531 Points

The lesson is about concatenation isn't it I realize what I needed to do but Thanks for your help