Hi Greg Try:-
Select * from police_stations where not HQ Regards Martin ----- Original Message ----- From: "Driver, Greg 9434" <[EMAIL PROTECTED]> To: "MapInfo-L (E-mail)" <[EMAIL PROTECTED]> Sent: Tuesday, May 18, 2004 9:06 AM 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. > > > --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11809
