Subject Re: [firebird-support] Re: indexing NULL and NOT NULL values
Author Richard Wesley
On Feb 15, 2006, at 05:23, Radu Sky wrote:

> WHERE my_field >= 0 combined with WHERE my_field IS NULL solved my
> problem, however (to be picky) this solution will not work unless
> it is
> known an imposed min/max value for <my_field> (which mostly is).

Then how about "where field >= 0 or field <= 0"?
________________________________________________________
Richard Wesley Software Engineer
Tableau Software
(w) +1-206-633-3400x505
hawkfish@...
http://www.tableausoftware.com/



----------


Visual Thinking for Business Intelligence



[Non-text portions of this message have been removed]