| Subject | Concatenated field return null when only one field is null |
|---|---|
| Author | Almond |
| Post date | 2005-06-27T13:52:39Z |
I have a computed field which concatenate 2 field :
PA_COLOR_GP_REF Computed by: (PA_COLOR_GROUP_CODE || ' ' || PA_COLOR_CUST_REF)
PA_COLOR_GP_REF return <null> if PA_COLOR_CUST_REF is null, even
PA_COLOR_GROUP_CODE contains data. I'm using firebird 1.0
Best regards,
Almond Wong
PA_COLOR_GP_REF Computed by: (PA_COLOR_GROUP_CODE || ' ' || PA_COLOR_CUST_REF)
PA_COLOR_GP_REF return <null> if PA_COLOR_CUST_REF is null, even
PA_COLOR_GROUP_CODE contains data. I'm using firebird 1.0
Best regards,
Almond Wong