RE: NULL value

• "Gogala, Mladen" <MGogala_at_oxhp.com> wrote:
  > It's stored in the column because NULL != NULL.
  > The only operators that can be applied to
  > the NULL value are IS and IS NOT. Nothing else.
  >
  

Not entirely true! - there is DECODE which can be applied to null values. In a DECODE expression, two null values are considered to be equivalent.

ie. DECODE ( expr, search1, result1, .. searchN, resultN, default)

If expr is NULL, returns the result of the first search that is also NULL.

Cheers! Received on Wed Oct 11 2000 - 05:19:15 CDT