On Tue, 18 May 2004, Driver, Greg 9434 wrote: > Err, I seem to be having a problem with something that should appear > straightforward! I've got a table with a number of logical fields and when > I query even field using the following: > > Select * from police_stations where HQ = "false" > > all that is returned are the records that are TRUE. I've tried using false, > F and >0 in the where condition but to no avail. So how do I go about > selecting those records that are false?
If HQ is a Logical type, then you should try this instead: Select * from police_stations where Not HQ or Select * from police_stations where HQ = 0 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11814
