Try: Left$(MyColumn, InStr(1, MyColumn, " ")-1)
In this instance, InStr() returns the position of the first space character. Subtract 1 from this to exclude the space itself in the label. Cheers, Peter -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Gosbell Sent: Monday, 16 January 2006 4:06 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