update your column like
update TABLENAME set
COLNAME = left$(colname,instr(1,colname," ")-1) +
right$(colname,len(colname) - instr(1,colname," "))
hope works..
-----Original Message-----
From: Steve Carlsson <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: 22 �ubat 1999 Pazartesi 11:47
Subject: MI Column formatting
>Hello Mappers!
>
>I have a street address column that looks as follows
>
>2 23 Smith Street
>
>and
>
>33 4 Jones Street
>
>The problem I have is that I want to be able to remove the space between
>the numbers....have been looking at instring and mid$ but cant see how
>they will help....
>
>any ideas
>
>TIA
>
>
>
>
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
