David Assuming you can do it in MapBasic, to get your label try:
lnPos1 = InStr ( 1, lcLot_string, " ") lnPos2 = InStr ( lnPos1+1, lcLot_string, " ") lcShort_string = Left$ (lcLot_string, lnPos2-1 ) HTH Terry -----Original Message----- Greetings List, I wish to label a map with an expression that would display all characters of a string until a second space is encountered. Example: "Lot 1 in blk 2 of Mapinfo Estates" I need to extract "Lot XX". To return: Lot 5 Lot 34 Etc. --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11811