On 25 May 2011 20:59, Olaf Kluge <olaf.kluge@...> wrote:

> 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?)

how about

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

if integervar is null then use the value '' (empty string)