| Subject | Re: [firebird-support] Concatenated field return null when only one field is null |
|---|---|
| Author | Paul Vinkenoog |
| Post date | 2005-06-28T01:00:25Z |
Hi Jason,
But please note that CASE, too, is not available in 1.0
Greetings,
Paul Vinkenoog
>>> Select Coalesce(PA_COLOR_GROUP_CODE, '') || ' ' ||Yes, if you like a lot of typing :-)
>>> Coalesce(PA_COLOR_CUST_REF, '')...
>> Coalesce is not available in 1.0 though. But if Almond uses the
>> Windows version, he can use the *NVL functions from the fbudf lib.
> OR!
>
> Select (Case When PA_COLOR_GROUP_CODE Is Null Then '' Else
> PA_COLOR_GROUP_CODE End) || ' ' || (Case When PA_COLOR_CUST_REF Is
> Null Then '' Else PA_COLOR_CUST_REF End) ...
But please note that CASE, too, is not available in 1.0
Greetings,
Paul Vinkenoog