Hi, I found answer,
left$(sitename, Instr(1,sitename,"_")-1) e.g. "Avenue Road _1(426)" it extracts "Avenue Road" Thanks & Regards Shashibhushan Shashi B Kumar/NW/BLR-MSC/ KA/TTSL To MapInfo-L@lists.directionsmag.com 20/09/2005 11:07 cc AM Subject Right trimming of a field Dear all, I have a field containing names along with some numbers e.g. "Avenue Road _1(426)" Now, I want to discard everything after "_" and update the same in the new field / right trim upto "_". Pls give me a syntax that I can use in mapbasic window. Thanks & Regards Shashibhushan The information contained in this email is confidential. It is intended only for the individual(s) named above. If the reader of this email is not the intended recipient, any distribution or copying of this email is prohibited. If you have received this email in error, please notify us by return email and delete all copies. --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 17927