Re: Null variables

Posted in 1998

Octav Chiriac — Fri, 14 Aug 1998 11:26:02 +0300 (EETDST) — source: Informix-list mailing list archive (1991-1998)

Florin Micle wrote: >Hi all, > > Does anyone know how can I see if a passed variable into a stored >procedure in Informix (dbaccess) has null value? I can't compare it with >null because I get a syntax error (null - undeclared variable) if I pass >null value into another variable the evaluation of null = null returns >false! I wish it returned true... > Can anyone give me a solution for this? > LET var = NULL; IF var IS NULL THEN -- It's TRUE END IF -- Octav Chiriac Phone: (373) 2 21 20 96 NetInfo S.R.L. Fax: (373) 2 21 20 96 Chisinau (373) 2 24 00 83 Moldova, Republic of mailto:com@netinfo.moldova.net