Dear Peter, * recognise evens and odds between given values e.g select all odds between 32 and 49. If you want you use plain SQL:
Select * From MyTable Where MyColumn > 32 And MyColumn < 49 And MyColumn Mod 2 = 1 Kind Regards, Pieter Ouwerkerk -----Oorspronkelijk bericht----- Van: Solominides, Peter [mailto:[EMAIL PROTECTED] Verzonden: maandag 9 augustus 2004 15:48 Aan: [EMAIL PROTECTED] Onderwerp: MI-L Odd & Even Integers 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 ********************************************************************** De disclaimer van e-mail van de gemeente Velsen vindt u op The e-mail disclaimer can be found here: http://www.velsen.nl/e-maildisclaimer0209.html ********************************************************************** --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 12885
