Subject RE: [firebird-support] NULL in concatenate
Author Alan McDonald
> Hi,
> 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
You need to test for NULL, assign either the non-null value or "" to a
variable before you concatenate the assigned variables
Alan