ra8009 wrote:

>In my select statement I want to concatenate first and last name if
>they both are not null. If one of them is null, I want to use just the
>not null value. How can I accomplish this?
>
>
>

Take a look on case and coalesce in the FB 1.5 release notes.

see you !

--

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