Subject Re: [Firebird-Architect] FB 2.0 Road Map
Author Jim Starkey
Jonathan Neve wrote:

>Along the same lines, I think it would also be good to have a
>"de-nullified" concatenation operator whereby null would be equivalent
>to '', that is:
>
>Value | null evaluates to Value
>
>What do you think?
>
>
>
I put three concatenation operators into Datatrieve -- strict
concatenate, concatenate after suppressing trailing blanks, and
concatenate with exactly one interventing space (aka junk mail concatenate).

That aside, would it make more sense to have an operator (or function)
that simply ditched the null? The proliferation and combination of
concatenate options makes one shudder.