Dear All, I have a very simple problem that I have been able to solve before but for some reason cant remember how I did it previously.
I have a table with approx 200 records. Each record in one of my columns has the prefix EHO1 then is followed by a four-digit number to differentiate each record from the rest. What I want to do is create a new column (in the same table) with just those four final numbers from each record being displayed (ie: truncating the number so only the final 4 numbers are displayed) I hope someone can help me with this. Many thanks in advance, Andrew Tracey Information Support Officer Corporate Information Corporate Development South Tyneside Council Westoe Road South Shields NE33 2RL Tel: 0191 4247561 E-Mail : [EMAIL PROTECTED] ************************************************************************************************ ************************************************************************************************ Please do not print this e-mail if you can help it - and help protect the environment. ************************************************************************************************ This email and any files transmitted with it are confidential and intended solely for the named recipient. If you have received this e-mail in error, please immediately notify the sender by e-mail and delete from your system, you are not permitted to disseminate, store, disclose or copy. E-mail transmission cannot be guaranteed to be secure or error-free as they could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses and therefore the Council accept no liability for any such errors or omissions. Views or opinions expressed in this email are solely those of the author and do not necessarily represent those of the Council. South Tyneside Council, Town Hall & Civic Offices, Westoe Road, South Shields, Tyne & Wear, NE33 2RL, Tel: 0191 427 1717, Website: www.southtyneside.info ************************************************************************************************ The Council's web site address is www.southtyneside.info _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l
