Databases Reporting with SQL Working with Text Concatenating Text

Cosmin Iuga
Cosmin Iuga
2,058 Points

I'm lost here. Here's another version I tried.

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

2 Answers

Pascal Breitrück
PRO
Pascal Breitrück
Pro Student 3,204 Points

Hey my Friend try this. :D

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

Sean T. Unwin
MOD
Sean T. Unwin
Treehouse Moderator 28,388 Points

Change the double quotes to single and remove the last || before the 'AS'