I guess that you want to find those records that not have been placed geographical on the map.
This is done using SQL where you just write NOT OBJ in the where field Peter Horsb�ll M�ller GIS Developer Geographical Information & IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -----Original Message----- From: John Nott [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 08, 2004 2:49 PM To: [EMAIL PROTECTED] Subject: MI-L Select by Attribute Hello All, I have a data set of about 35,000 businesses which I am trying to geocode using a table with all UK postcode centroids. Out of the 35,000 business postcodes about 5,000 do not match as they have wrong postcodes. I am trying to do a query that will highlight all the non - matching ones into a table. I have tried using the <> sign in the original query but to no avail. I suspect that there is quite an easy solution, however I just can't think what it is!!! Any Suggestions would be much appreciated Cheers, - John John Nott Consultant/GIS Analyst ROGER TYM & PARTNERS Fairfax House, 15 Fulwood Place, London, WC1V 6HU t 020 7831 2711 f 020 7831 7653 e [EMAIL PROTECTED] w www.tymconsult.com The information in this email is confidential. It may also be legally privileged. It is intended only for the stated addressee(s) and access to it by any other person is unauthorised. If you are not an addressee, you must not disclose, copy, circulate or in any other way use or rely upon the information contained in this email. Such unauthorised use may be unlawful. If you have received this email in error, please reply immediately to this effect and delete it (and all copies) from your system (with thanks). This message and any attached files have been scanned for the presence of computer viruses. However, you are advised that you open any attachment at your own risk. --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 14425
