Re: [dba-users] SQL string concatenation that does not return NULL if one argument is NULL

[Regina Henschel]

Hello Emil,

Emil Karlen schrieb:
In

SELECT column1 + column2

the result is NULL is one of the columns is NULL.
I want an expression that, if only one of the columns is NULL, returns the
other column. Is there any such operator or function?


Perhabs you can add 0. For that you can use COALESCE("colum1",0) instead 
of "column1". (for HSQL)

kind regards
Regina

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]