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

[Emil Karlen]

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?

/Emil Karlén

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