Hello,



I like set a string-output: 'Text ' || :integervar || ' Text'



If the integervar is null, the entire string is null. Now I can do the
following:



'Text ' || COALESCE(:integervar,'NULL') || ' Text'



Is there a function available like 'nz(.)' - if is null then returns 0 in
firebird? (If nullstring, then emty string?)



Thank you.



Regards.



Olaf



[Non-text portions of this message have been removed]