Re: Select Statement Q!!!

Posted in 1998

Sujit.Pal@alltel.com — Wed, 4 Mar 1998 08:06:46 -0600 — source: Informix-list mailing list archive (1991-1998)

Raymond IMO this is the way it is supposed to work. If you want to get null values you would need to add: or fld1 is null to your query. HTH Sujit Pal ______________________________ Reply Separator _________________________________ Subject: Select Statement Q!!! Author: "Pinto; Raymond" <PINTOR@valuerx.com> at Internet Date: 3/3/98 5:17 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