Not a feasable solution with literally thousands of filters assigned
everywhere. Besides the problme is the null. If a field is left null, its
order in the search is not teh same as blank or 0.

Using a statement such as (xx > 0) fails to find them and so does (xx<=
0).... it is illogical. It should be in one or the other set.
Unfortunately the defaults in Interbase do not work when using IBO.

IBO should save '' and 0 for nulls in strings and integers.

----- Original Message -----
From: "Woody" <woody.tmw@...>
To: <ib-support@yahoogroups.com>
Sent: Friday, 8 June 2001 12:08
Subject: Re: [ib-support] Null


> simply put in
>
> where (Field is null or Field < 0)
>
>
> HTH
> Woody
>
> ----- Original Message -----
> From: Sandeep
> To: ib-support@yahoogroups.com
> Sent: Thursday, June 07, 2001 7:07 PM
> Subject: [ib-support] Null
>
>
> I have some columns where I have some null values. When I query
> the table with condition like [field < 0] i don't get the records with
> null values. I have prdefined conditions in my application and I don't
> want to change these. How do I get around this problem.
>
> Thanx in advance
>
> Sandeep
>
> Software Developer
> CFL
> sandeep@...
> http://www.cfl.co.nz
>
>
> Yahoo! Groups Sponsor
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
>
>
> [Non-text portions of this message have been removed]
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>