Paul Vinkenoog wrote:

> Hi Jason, Almond,
>
>
>>Select Coalesce(PA_COLOR_GROUP_CODE, '') || ' ' ||
>>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.
> More info here:
> http://www.firebirdsql.org/manual/nullguide-dealing-with-nulls.html#nullguide-subst-with-value
>

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) ...

Jason