Mike, To get rid of the combined county and postcode entries use:
Update Column Table to update 'yourtable' Column to update 'yourcolumn' Get value from table 'yourtable' Value - Left$(yourcolumn,(len(yourcolumn)-8)) This removes the last eight digits from each string. The '8' is based on the seven figure postcode plus a space after the name. If you need to save the entries which just have a postcode, use select "_______" - seven underscores, which will select only the records with seven figures. Andrew Young Durham City -----Original Message----- From: Mike Stein [mailto:[EMAIL PROTECTED]] Sent: 10 December 2002 09:29 To: '[EMAIL PROTECTED]' Subject: MI-L RE: SQL problem I have a table of over 100o records and am trying to filter out some the county names. They appear for example as: Merseyside L35 4PQ Cheshire WA3 2AR Dumfriesshire DG10 9NP CA10 2HD Nr Carluke Does anyone know of a way to update the column leaving only the county name and erasing the postcaode? Mike Stein GIS Consultant RSK ENSR GROUP Tel: +44(0)1928 726006 Fax: +44(0)1928 725633 [EMAIL PROTECTED] http://www.rsk.co.uk --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 4463 IMPORTANT NOTICE: This e-mail is confidential. It must not be read, copies disclosed or used by any person other than the main recipient. Unauthorised use, disclosure or copying is strictly prohibited and may be unlawful. If you have received this e-mail in error, please contact the sender immediately.
