On Thu, Aug 25, 2011 at 8:52 AM, Oliveiros d'Azevedo Cristina
<oliveiros(dot)cristina(at)marktest(dot)pt> wrote:
> Something like this...?
>
> SELECT first_name,surname, email1 || ';' || email2
> FROM t_your_table;
If there's any nulls in email1 or email2 they'll need special handling
with coalesce.