| Subject | RE: [firebird-support] NULL in concatenate |
|---|---|
| Author | Alan McDonald |
| Post date | 2003-12-28T11:35:10Z |
> Hi,You need to test for NULL, assign either the non-null value or "" to a
> How I can solve this expression won't be null if one of the variables is
> null (AGE is null):
>
> PPARAM = '''' || NAME || ''',' || AGE || ',' || POSITION;
>
> Thanks
> Filip
variable before you concatenate the assigned variables
Alan