Thanks to Mark, Martin and Photogrammetry GIU (!) who suggested either inverting the selection or using the following : Select * from police_stations where not HQ
Thanks Guys. > -----Original Message----- > From: Driver, Greg 9434 > Sent: Tuesday, May 18, 2004 09:07 > To: MapInfo-L (E-mail) > Subject: MI-L Logical fields in SQL select > > 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? > > Thanks > > Greg Driver > > > > > Internet communications are not secure and therefore Surrey Police does > not > accept legal responsibility for the contents of this message. This email > and any attachments may be confidential. They may contain privileged > information and are intended for the named addressee (s) only. They must > not > be distributed without our consent. If you are not the intended recipient, > please notify us immediately and delete the message and any attachments > from > your computer, do not disclose, distribute, or retain this email or any > part > of it. Unless expressly stated, opinions in this email are those of the > individual sender, and not of Surrey Police. We believe but do not warrant > that this e-mail and any attachments are virus free. You must therefore > take > full responsibility for virus checking. Surrey Police reserves the right > to > monitor all email communications through their networks. > > > > Internet communications are not secure and therefore Surrey Police does not accept legal responsibility for the contents of this message. This email and any attachments may be confidential. They may contain privileged information and are intended for the named addressee (s) only. They must not be distributed without our consent. If you are not the intended recipient, please notify us immediately and delete the message and any attachments from your computer, do not disclose, distribute, or retain this email or any part of it. Unless expressly stated, opinions in this email are those of the individual sender, and not of Surrey Police. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking. Surrey Police reserves the right to monitor all email communications through their networks.
