Have you tried:
Left$([YOURFIELD],Instr(1,[YOURFIELD], )-1)
HTH
David
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of John Gosbell
Sent: Sunday, January 15, 2006 11:06 PM
To: mapinfo-l@lists.directionsmag.com
Subject: [MI-L] Creating Labels using Space
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
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