I'm having trouble displaying the "<" and ">" around the email.

Thanks for the quick response! Here's the link to the challenge page:

https://teamtreehouse.com/library/reporting-with-sql/working-with-text/concatenating-text

Here's my query:

SELECT first_name || " " || last_name || " <" || email || "> " AS to_field FROM patrons WHERE first_name = "Andrew" AND last_name = "Chalkley";

The challenge says to do this "for all users".

So remove your "WHERE" clause.
And don't forget to remove that extra space after the ">" — the challenge doesn't like that!

Also, even when you get it right you still won't see the email portion in the output. It's probably some HTML encoding bug.

WOW didn't see that part of the question haha...

Hm this time the full names of everybody in "patrons" showed up, but the emails are still missing though.

-edited, added query and resulting report-

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

to_field Andrew Chalkley Dave McFarland Alena Holligan Michael Poley

But there's still the problem that it;s trying to find the email part of the string but it;s not finding. But the emails are in a differnt format.

I tried to solve that with this

SELECT first_name || " " || last_name || " <" || LOWER(first_name) || "@teamtreehouse.com" ||"> " AS to_field FROM patrons;

But no joy. We need the spaces too as this is how the example is presented in the question.

Amos Wu, see my caveats about the extra space and the bug about the email in the output above.

Once you get rid of that extra space, you'll have it:

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

It's been a little while since I did any SQL but I'm baffled lol

SELECT first_name || " " || last_name || " " || "<" || LOWER(first_name) || "@teamtreehouse.com" ||">" AS to_field FROM patrons;

This should work.

Jonathan, the email might be made up from the name, but you can't count on it. You have to use the email field to be sure.

Oh yes by all means take the email field but the data is andrew.chalkley@teamtreehouse.com rather than

Generate a list of strings that are in the following format: Andrew Chalkley <andrew@teamtreehouse.com>. 

Which is what throws me. :)

Great job, Amos!

Clearly that;s the answer the task was looking for but in actuality there;s more than one way to solve the problem.

Because including the email field like you did there doesn't actually change the format of the email string. The email in the date is in a first_name.last_name format rather than in a first_name format which is what baffles me.

Anyway, great job on passing! :-)

Actually, having the space and the angle together was a good idea. You get the same result concatenating them, but combining two literal strings programmatically seems a bit silly.

And for Jonathan, the email might be made up from the name, but you can't count on it. You have to rely on the email field to be sure.

I thought i was being quite creative by concatenating the first_name in the LOWER function and using the @teamtreehouse string of the email. But like I say... different answers solve the problem but not for this code challenge which often wants something specific :-)