In Firebird 1.5.x, you can used
select CUST_KEY, COALESCE(CUST_NAME1, '') || ' ' ||
COALESCE(CUST_NAME2, '') AS
CUST_FULL_NAME from
CUSTOMERS


--- Planles <planles@...> a écrit :

> 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
>
>
>
> ------------------------ Yahoo! Groups Sponsor
> --------------------~-->
> Make a clean sweep of pop-up ads. Yahoo! Companion
> Toolbar.
> Now with Pop-Up Blocker. Get it for free!
>

http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/67folB/TM

>

--------------------------------------------------------------------~->

>
>
>
> Yahoo! Groups Links
>
>
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
>

Vous manquez d’espace pour stocker vos mails ?
Yahoo! Mail vous offre GRATUITEMENT 100 Mo !
Créez votre Yahoo! Mail sur http://fr.benefits.yahoo.com/

Le nouveau Yahoo! Messenger est arrivé ! Découvrez toutes les nouveautés pour dialoguer instantanément avec vos amis. A télécharger gratuitement sur http://fr.messenger.yahoo.com