> 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.

The double pipe symbol || is the concatenating operator.

Sec1.FIRST_NAME || ' ' || Sec1.LAST_NAME



--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database and MS SQL Server
Upscene Productions
http://www.upscene.com