Planles wrote:

>Hi!
>
>I use following sql to get customers id and ful name:
>
>select CUST_KEY,CUST_NAME1 || ' ' || CUST_NAME2 AS CUST_FULL_NAME from
>CUSTOMERS
>
>The problem is, if there is no CUST_NAME2 defined (value of CUST_NAME2 is
>NULL), there is also CUST_FULL_NAME for this customer NULL.
>
>Example:
>NAME1 = Primoz
>NAME2 = Planinc
>
>FULL_NAME = Primoz Planinc
>
>
>But if:
>NAME1 = Primoz
>NAME2 =
>
>FULL_NAME =
>
>But it should be
>
>FULL_NAME = Primoz
>
>How can I solve this problem ?
>
>Regards,
>Primoz
>
>

Primoz,

If you are using FB 1.5 take a look at coalesce function and/or case
statement on release notes.

see you !

--

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