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]