| Subject | Re: [firebird-support] Concatenated field return null when only one field is null |
|---|---|
| Author | Martijn Tonies |
| Post date | 2005-06-27T13:55:19Z |
> I have a computed field which concatenate 2 field :PA_COLOR_CUST_REF)
>
> PA_COLOR_GP_REF Computed by: (PA_COLOR_GROUP_CODE || ' ' ||
>Works as designed.
> 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
With regards,
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com