here ya go, this should werk... ##################### Left$(YOURFIELD, InStr(1, YOURFIELD+" ", " ")-1) #####################
the YOURFIELD+" " is in case your field value doesn't have a space in one of them so it won't return zero on the instr command, it'll give back 1 greater than the len of the string. btw, there's no smith st in smithfield, and only 5 suburbs have a 27 smith st in them. plus, stay away from smithfield, land of Fubu Maternity-wear, ick.... :) ash -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Gosbell Sent: Monday, 16 January 2006 3:36 PM To: mapinfo-l@lists.directionsmag.com Subject: [MI-L] Creating Labels using "Space" as a delimiter.... Howdy, I have a field containing formatted street address (eg "27a Smith St, Smithfield" ) and I want to create a label displaying just the house number (eg "27a"). I'm using MapInfo Pro Version 6.0. Have looked at all the label string functions as hoped to use the first space in the string as a delimiter, but no joy Does anyone have any bright ideas ? Cheers John Gosbell GIS Administrator City of Burnside P: 8366 4130 (direct) F: 8366 4299 E: [EMAIL PROTECTED] This Email is personal correspondence from the sender. It is not an official document from the City of Burnside. _______________________________________________ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l _______________________________________________ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l