Correction - I should have said for EVEN in where condition : not (ID mod 2)
GH -----Original Message----- From: Gilbert Haché [mailto:[EMAIL PROTECTED] Sent: August 9, 2004 10:20 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: MI-L Odd & Even Integers You can use SQL SELECT and choose Where condition : ID mod 2 And ID > 32 and ID < 49 for the ODD or where condition ID <> (ID mod 2) And ID > 32 and ID < 49 for EVEN You can use your Mapbasic windows to make (or see the result) of those queries Select * from Outlets where ID mod 2 And ID > 32 and ID < 49 into ODD Browse * From ODD Select * from Outlets where ID <> (ID mod 2) and ID > 32 and ID < 49 into EVEN Browse * From EVEN Gilbert Dear List, A blindingly simple question, but something im having trouble with. If I have 100 records in a table, each with an integer value for the ID column (not RowID, just a column I put in), can I get MapInfo to recognise and select all the evens, or all the odds? can I then get it to recognise evens and odds between given values e.g select all odds between 32 and 49. Thanks for help in advance P Peter Solomonides <Technician> ΛTKINS Rivers & Coastal Thomson House Birchwood Park Risley, Warrington WA3 6AT 01925 62 2015 07734859137 View 'Alliance' Issue 3: our new Atkins Newsletter for work let by the Environment Agency < http://www.atkinsglobal.com/wsainternet/markets/water/relatedinformation/41 49163_alliance_issue3_for_.pdf> This email and any attached files are confidential and copyright protected. If you are not the addressee, any dissemination of this communication is strictly prohibited. Unless otherwise expressly agreed in writing, nothing stated in this communication shall be legally binding. --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 12883 Disclosure of Material Facts Every Proposer or Insured / Reinsured when seeking new insurance / reinsurance or renewing an existing Policy must disclose any information which might influence the Insurer / Reinsurer in deciding whether or not to accept the risk, what the terms should be, or what premiums to charge. Failure to do so may render the insurance / reinsurance voidable from inception and enable the Insurer / Reinsurer to repudiate liability. This email, together with any attachments, is for the exclusive and confidential use of the addressee(s) and may contain legally privileged information. Any other distribution, use or reproduction without the sender's prior consent is unauthorised and strictly prohibited. If you have received this message in error, please notify the sender by email immediately and delete the message from your computer without making any copies. While attachments are virus checked, Aon Limited does not accept any liability in respect of any virus which is not detected. Aon Limited Company Number: 210725 Registered Address: 8 Devonshire Square, London, EC2M 4PL Aon Limited is a member of the General Insurance Standards Council (registration 2239) --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 12887 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 12889