Databases Reporting with SQL Working with Text Concatenating Text

Tom Holliday
Tom Holliday
2,718 Points

I don't understand how we are supposed to know what the correct email formatting is. Are we supposed to add the < signs?

I've tried so many combinations but none of them work e.g. SELECT first_name || " " || last_name || " " || email AS "to_feild" FROM patrons; SELECT first_name || " " || last_name || " <" || email || ">" AS "to_feild" FROM patrons; SELECT first_name || last_name || email AS "to_feild" FROM patrons; SELECT first_name || " " || last_name || " <" || email || ">."AS "to_feild" FROM patrons;

I tried more than that but you get the idea.

1 Answer

Steven Parker
Steven Parker
203,989 Points

You're right about needing the angle symbols. And your 2nd try would have passed except for spelling the alias as "to_feild" instead of "to_field".

Fix that and you've got it.

Tom Holliday
Tom Holliday
2,718 Points

bruh I'm too smart, Thanks.