Bonjour Éric,
1. Add the 0
-Table/Update Column.
-Select your table and the field you want to update
-Click on the "Assist" button and type "0" + Yourfield and Ok buttons
2. Delete the 0
-Table/Update Column.
-Select your table and the field you want to update
-Click on the "Assist" button and type Right$(Yourfield,6) and Ok buttons
En espérant que ça puisse t'aider!
Bye
François Bergeron
GIS Analyst
KOREM Inc.
-----Message d'origine-----
De : [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]De la part de Eric
Gagnon
Envoyé : 15 janvier, 2001 13:53
À : MapInfo-L
Objet : MI-L modifying info..
hello people..
I have this problem..
I'm trying to do an SQL select..
I got 2 table.. and one common column.. the columns contain numbers ex:
235647
The catch is, in one table there's a zero 0 in from of the numbers ex:
0235647
I want to like shrink this column so I can get the zero out.. or maybe
add a zero to the other column in the other table..
Is there a way I can fix this problem.. I have close to 40,000 entries
in these columns.
Thankx,
Eric.
--
Eric Gagnon
GIS Technician
La Commission du District d'Aménagement de la Vallée
Tel.: (506) 475-2511
Fax.: (506) 475-2516
e-mail: [EMAIL PROTECTED]
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
