RE: Select Statement Q!!!

Posted in 1998

Pinto, Raymond — Wed, 4 Mar 1998 10:43:13 -0600 — source: Informix-list mailing list archive (1991-1998)

Hi All, Thanks for the info. I knew about the way nulls are treated. It makes sense. So it is not a bug. Raymond Pinto pintor@valuerx.com > ---------- > From: Pinto, Raymond[SMTP:PINTOR@valuerx.com] > Sent: Tuesday, March 03, 1998 3:18 PM > > Q. I have a query > > select count(*) from table_a > where fld1 != 'A'> > I get a count = 7000 > fld1 is char(1) > There are 100000 records with fld1 = null > > This query does not count the null values > > From what I can see , Informix does not count the null values. Is this > a > bug or is this the way it is supposed to work > > Thanks in advance > > Raymond Pinto > pinto@valuerx.com >