Re: NULL peeve

->From: Jack Parker <jparker@hpbs2561.boi.hp.com> ->Subject: peeve ->To: informix-list@rmy.emory.edu (Informix Users Net) ->Date: Tue, 11 May 93 11:32:28 MDT -> ->I hate fixing a statement from: -> ->IF a != b THEN ..... -> ->TO -> ->IF a != b ->OR (a IS NULL AND b IS NOT NULL) ->OR (a IS NOT NULL AND b IS NULL ) THEN ..... -> --> --> Sorry, Jack. Don't hold your breath waiting for this to be "fixed", since --> Informix does not consider it to be broken. --> --> IF expression THEN --> statement(s) --> ELSE --> statement(s) --> NULL { or maybe ON NULL } --> statement(s) --> END IF --> --> With this enhancement, if the (ON) NULL part of the IF structure were --> omitted, then "expression with NULL" should still take the ELSE branch, --> for compatibility with existing programs. Sounds like a great idea ... now how about math with NULLS, can't we have some way of treating them like zeros? Fred H. Berns Systems Administrator Kestnbaum & Company Chicago, Illinois Email: kestnb!fhb@uunet.uu.net ----- End Included Message -----