RE: [MI-L] CONTOUR QUERY

[Llewellyn, David]

Title: CONTOUR QUERY

Peter,   One way that comes to mind would be to add an integer column to the table and populate it with an integer representation of the contour value (999.5 becomes 9,995 for instance).   Then you could use the ‘Mod’ oprator in SQL to sift them (Select Where ‘IntegerValue’ mod 5 = 0) changing the value as required.   Cheers,   David Llewellyn.   -----Original Message----- From: Peter Hatton [mailto:[EMAIL PROTECTED] Sent: Friday, 17 March 2006 10:06 AM To: mapinfo-l@lists.directionsmag.com Subject: [MI-L] CONTOUR QUERY                     Hi all,                                 After some help with the following .........  I have a table of contours that are at 0.5m increments and range in value from 0.00 to 999.5m - table structure : decimal. I would like a quick way to sift out contours by varying increments values ....eg: all contours at 5.0m increments ...... all at 10.0m increments.                 Have tried by SQL but can't quite work it out .......                                 Many thanks                                                            Regards                                                                     Peter   Peter HATTON GIS Officer Greater Taree City Council 2 Pulteney Street TAREE 2430 phone 02 6592 5227 e-mail     [EMAIL PROTECTED] gov.au This e-mail has been scanned for viruses by MCI's Internet Managed Scanning Services - powered by MessageLabs. For further information visit http://www.mci.com This email and any files transmitted with it are intended solely for the use of the individual or entity to whom they are addressed. Greater Taree City Council is a government organisation and is subject to Freedom of Information legislation. You must assume that any material sent to Greater Taree City Council may be accessible by persons other than the intended recipient. The contents of this message may express views and opinions not necessarily shared by Greater Taree City Council. ***This Email, together with any attachments is intended for the addressee only. If you have received this Email in error please inform the sender immediately by return Email. Alternatively you can ring the National Native Title Tribunal on the toll free number 1800 640 501 and report the error. Please delete the Email and any copies from your computer and/or computer network. The Tribunal does not warrant that this email is virus free. The Tribunal has also implemented content filtering of Emails to restrict inappropriate and spam emails being received. Other emails which may contain viruses may also be blocked. In either case, and in any case the email may not reach its intended recipient. If the email is important you may wish to see confirmation of its receipt by placing that request in the text of the email. Please resend the email if you haven't received that confirmation as requested. ***

_______________________________________________
MapInfo-L mailing list
MapInfo-L@lists.directionsmag.com
http://www.directionsmag.com/mailman/listinfo/mapinfo-l