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