>
> I was hopping that in a SELECT I could replace the data from the email
> column to something else...
>
>
> maybe email = name_first + name_last? Is that possible?
>
> I can't overwrite the data into that column... that has to be done by
> the select (if possible)
SELECT <item1>, <item2>, ..., name_first || ' ' || name_last AS email
FROM ...
You can't use SELECT *, you must list everything but email.