Subject Re: [ib-support] returning NULL values
Author Svein Erling Tysvær
NULL is IB/FBs way of storing something unknown and is not the same as 0.
If you have $100 and buy something which you cannot remember how much cost
- that does not mean that you still have $100 afterwards. So the best thing
you can do if NULLs in B.FIELD2 is to be treated as 0 is to change it to 0.
If this isn't feasible, do as Javi adviced or write a SP to replace your
select statement.