When I try to use COALESCE it just gives me the last name when both
the first name and last name exist. If both exist I want both. Is
there a way to do this with COALESCE?

--- In firebird-support@yahoogroups.com, Alexandre Benson Smith
<iblist@t...> wrote:

> 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