|
Regarding converting a NULL into something useful - use COALESCE. Try running this in the Command Window (? outputs the result of an expression, it's a special command in the Command Window): ?COALESCE(NULL, NULL, 1/0, NULL, 5, 8) The function walks through the arguments and returns the first non-NULL value. The first four values are NULLs and are skipped, the fifth produces the result, the sixth is ignored.
|