| Subject | Re: [firebird-support] Concatenated field return null when only one field is null |
|---|---|
| Author | Ivan Prenosil |
| Post date | 2005-06-28T07:00:19Z |
> Select Coalesce(PA_COLOR_GROUP_CODE, '') || ' ' ||You may also want to avoid leading space:
> Coalesce(PA_COLOR_CUST_REF, '')...
Select Coalesce(PA_COLOR_GROUP_CODE || ' ', '') ||
Coalesce(PA_COLOR_CUST_REF, '')...
Ivan
http://www.volny.cz/iprenosil/interbase/