Hallo, Emil,

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

You should write:

SELECT "column1", "column2", "column1" + "column2" AS "column" FROM
"Table" "Table"

Greetings
Jörn


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

Reply via email to