| Subject | Re: [ib-support] returning NULL values |
|---|---|
| Author | Svein Erling Tysvær |
| Post date | 2002-04-18T09:22:45Z |
Maria,
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.
Set
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.
Set