Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Testing Boolean fields with SQL

0 views
Skip to first unread message

Trevor Sleeman (Darta Computers)

unread,
Feb 28, 1998, 3:00:00 AM2/28/98
to

hi

I have a database table with a true/false field. I need to set up a query to
pull out only records with a false value in this field. What syntax do I
use for the SQL statement?
thanks in advance
Trevor

Panzer

unread,
Mar 2, 1998, 3:00:00 AM3/2/98
to

Try this in your Where clause of you SQL statement:

Where FOO.BAR = false

0 new messages