Pretty close, just use 2 of these things |


I would use the 'as FullName' so you have something sensible to work
with.


select
s1.ID,
s1.CAMPAIGN_NAME,
s1.FIRST_SEND,
s1.estimated_batch_size,
s1.created,
Sec1.FIRST_NAME || ' ' || Sec1.LAST_NAME as FullName
from ......



--- In firebird-support@yahoogroups.com, "Martin Catherall" <mc@w...>
wrote:

> hi
>
> I am trying to concatenate the values of two seperate string

(varchar)

> columns into a single column.
> I am having a bit of a problem here, (have tried + and & which do

not

> work)
>
> select
> s1.ID,
> s1.CAMPAIGN_NAME,
> s1.FIRST_SEND,
> s1.estimated_batch_size,
> s1.created,
> Sec1.FIRST_NAME + ' ' + Sec1.LAST_NAME /*NOT Valid in
> firebird...*/
> from ......
>
>
> can anybody point me to the correct way to preform this.
>
> cheers
>
> martin.
>
> =========================================================
> This e-mail has been scanned for Viruses and Content and cleared by

CommArc Cube Server

>
>
> [Non-text portions of this message have been removed]