I know there has to be an easy way to do this, but I can't figure it out
right now.
I have a field I want to join two tables on, but on of the tables has 00
infront of each number. Ex want to join one field (value =1) and other
field (value = 001). Does anyone know the syntax to removes these 0'
them
Of course make backup copies, before changing the field types.
Regards
Uffe
- Original Message -
From: "Ronning, Christine" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, April 05, 2005 5:49 PM
Subject: MI-L Removing 0's
I know there has to be an easy way to do this,
Brix Lyng
Frederikshavn Municipal Administration
Denmark
-Oprindelig meddelelse-
Fra: Ronning, Christine [mailto:[EMAIL PROTECTED]
Sendt: 5. april 2005 17:50
Til: mapinfo-l@lists.directionsmag.com
Emne: MI-L Removing 0's
I know there has to be an easy way to do this, but I can't