RE: [pilot-db-list] Search boolean fields

[KANE P. (CA) <Pet...@er...>]

search for a 1 or 0

-----Original Message-----
From: pil...@li...
[mailto:pil...@li...]On Behalf Of Markus
Voss
Sent: Monday, 21 July 2003 22:26
To: pil...@li...
Subject: [pilot-db-list] Search boolean fields


Dear all,

is there any way of searching for a "X" / or " " in a boolean field?
I created a database with a set of boolean fields and want to filter
according to certain fields set.

I tried the obvious search string "X" but no result. Any other idea?
Or do I have to go back to a string field?

Thanks,
Markus.



This e-mail (including any attachments) may contain confidential or
privileged information and is intended for the sole use of the person(s) to
whom it is addressed. If you are not the intended recipient, or the person
responsible for delivering this message to the intended recipient, please
notify the sender of the message or send an e-mail to
mailto:hel...@er... immediately, and delete all copies. Any
unauthorised review, use, alteration, disclosure or distribution of this
e-mail by an unintended recipient is prohibited. Ergon Energy accepts no
responsibility for the content of any e-mail sent by an employee which is=
 of
a personal nature.

Ergon Energy Corporation Limited      ABN 50 087 646 062
Ergon Energy Pty Ltd      ABN 66 078 875 902