Subject RE: [firebird-support] NULL in concatenate
Author Alan McDonald
> Is there any UDFs that do following:
>
> If param pased to it is NULL returns string NULL else passed param
>
> Ex:
> PPARAM = udf_null_int(AGE); -- AGE is NULL
>
> Result:
> PPARAM = "NULL"
>
> For various data types.
> Thanks
> Filip

There is a COALESE function built-in to the server now - read the release
notes for 1.5
Alan