Subject | Re: [firebird-support] Re: Calc field displays blank if 1 field is blank |
---|---|
Author | Alexandre Benson Smith |
Post date | 2004-08-02T19:45:12Z |
ra8009 wrote:
see you !
--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br
>In my select statement I want to concatenate first and last name ifTake a look on case and coalesce in the FB 1.5 release notes.
>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?
>
>
>
see you !
--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br