Databases Reporting with SQL Working with Text Concatenating Text

Van Nguyen
Van Nguyen
2,367 Points

Where can I put the angle bracket around the email?

I tried this one , seemed ridiculous .

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

I could not think about something else this stage, please help.

Van,

Markus Lysgaard
Markus Lysgaard
3,123 Points

Hi,

If you look after the ">" you have added ||. That will try to merge AS with the rest. I did that mistake too heh.. Just remove that and you should be fine:)

Your anwser: SELECT first_name || " " || last_name || " <" || email || ">." || AS "to_field" FROM patrons;

Right anwser: SELECT first_name || " " || last_name || " <" || email || ">." AS "to_field" FROM patrons;