'Your query didn't retrieve the emails in the correct format.' But the query is giving the same result in the workspace.
Why is this happening? What am I missing here?
Thanks for replying Steven. I have pasted the code below. But it works now! I don't know what mistake I was making.
SELECT first_name || ' ' || last_name || ' <' || email || '>' AS to_field FROM patrons;