Re: where != and NULLs

Posted in 1996

Carlos Costa e Silva — 29 Aug 1996 21:40:35 GMT — source: Informix-list mailing list archive (1991-1998)

If X is null then it's standard SQL that that X = 'value' is false and X != 'value' is also false. You can only do <where X is [not] null>. ccs. -- Carlos Costa e Silva ccs@minimal.pt Peter Wages <pmwages@cais.com> wrote in article <4vsllu$e0k@cssun.mathcs.emory.edu>... : Peculiar Circumstance in Version 7. Is this a bug? [snip] : : Me thinks there is a logic problem here. If column_2 is NULL then : column_2 != 'value' :