* IvanLatysh
> >> I've got query like this:
>
> >> "select count(ID) from TABLE where (TABLE.A + TABLE.B + TABLE.C +
> >> TABLE.D) > 0"
>
> >> A,B,C,D are decimal values.
>
> >> The problem is, I think, with NULL columns. Often B,C and D don't
> >> have decimal value, but NULL.
> >> I thoug
>> I've got query like this:
>> "select count(ID) from TABLE where (TABLE.A + TABLE.B + TABLE.C +
>> TABLE.D) > 0"
>> A,B,C,D are decimal values.
>> The problem is, I think, with NULL columns. Often B,C and D don't
>> have decimal value, but NULL.
>> I thought, that this should be counte
* Przemyslaw Popielarski
> I've got query like this:
>
> "select count(ID) from TABLE where (TABLE.A + TABLE.B + TABLE.C +
> TABLE.D) > 0"
>
> A,B,C,D are decimal values.
>
> There are over 1 records where A is greater than 0,
> about 1000 where B is greater than 0,
> about 500 where C is
Hi,
I've got query like this:
"select count(ID) from TABLE where (TABLE.A + TABLE.B + TABLE.C + TABLE.D) >
0"
A,B,C,D are decimal values.
There are over 1 records where A is greater than 0,
about 1000 where B is greater than 0,
about 500 where C is greater than 0,
and about 300 where D is
