Hello, I have a table of postcodes (over 200,000), and for querying purposes I need to remove all spaces from the text, e.g. E1 0AA to look like E10AA. How do I do this?!
Thanks in advance, Sarah *********************************************************************************** The contents of the e-mail and any transmitted files are confidential and intended solely for the use of the individual or entity to whom they are addressed. Transport for London hereby exclude any warranty and any liability as to the quality or accuracy of the contents of this email and any attached transmitted files. If you are not the intended recipient be advised that you have received this email in error and that any use, dissemination, forwarding, printing or copying of this email is strictly prohibited. If you have received this email in error please notify [EMAIL PROTECTED] This footnote also confirms that this email message has been swept for the presence of computer viruses. *********************************************************************************** --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11861
