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.

Reply via email to