How to add more strings at the end when concatenate columns using || in SQL?

To get it in this form : Andrew Chalkley How to get the >. at the end into the new column My answer is the following which is wrong SELECT first_name ||" "|| last_name ||" <"|| email ||">."|| AS"to_field" FROM patrons;

1 Answer

Steven Parker
Steven Parker
182,307 Points

You're really close, but you don't need the extra || symbols between the string and the AS. Also, I don't think you need a period after the ">". Fix those and I think you'll have it!

I got it now. Thank you