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]