Hi, Robert !

Robert martin wrote:

>Hi All
>
>I have 2 fields, only one of which will ever contain text, the other will
>always be null. I wanted to add a third field that was A || B but only get
>Null results. Is there a way to do this with a simple select?
>
>
>Rob Martin
>Software Engineer
>
>phone 03 377 0495
>fax 03 377 0496
>web www.chreos.com
>Wild Software Ltd
>
>
>
>

if the other will be alays null why do you need to concat it ???

try this:

select A || Coalesce(B, '') from MyTable

works on FB 1.5

see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br