Re: FX Calculations for Columns with Null

[Joshua V]

What are the benefits of doing it this way?

[ParaSQL Support]

In SQL a NULL value combined in most ways  (e.g. most math operations, string concatenation, etc.) with other non-NULL values makes the entire result NULL. This is often undesirable. For example, NULL + 1 = NULL (not 1 as many would think).