Hi John, Just go for query> SQL select (select from tab-name where not obj). it will retrieve all rows which not gecoded.
Thanks Ami Amel H.Assad Deputy Managing Director DotMap S.A.E. 13 Themar St., Moustafa Mahmoud Sq., Mohandsseen, Cairo, 12311, Egypt Tel: 20-2-336-6035 Fax: 20-2-761-6922 Mobile: 20-12-325-8182 www.dotmap.com.eg -----Original Message----- From: John Nott [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 08, 2004 3: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: 14426