1 Answer

email isn't an alias. Nor is there a concatenation function in SQLite. Use the concatenation operator. Just make sure the angle brackets and any spaces are enclosed in quotes and email isn't. For example

SELECT'<'||email||'>'ASformatted_emailFROMpatrons;

will retrieve:

<andrew@teamtreehouse.com>

as formatted_email for a record with andrew@teamtreehouse.com in the email field.

Posting to the forum is only allowed for members with active accounts.
Please sign in or sign up to post.