Remove Zero?!? Need help (1 Viewer)

T

tsnorgaard

Guest
Hi !
I need to remove the a zero in a table.
I know how to chage the type a data to numbers, bu my data includes also letters.

ex.

Tabel 1:
001
002
007
008
010
001a
002b
010a

Result:
1
2
7
8
10
1a
2b
10a

Please help me I´m going out of my mind.

Thomas
 

namliam

The Mailman - AWF VIP
Local time
Today, 20:07
Joined
Aug 11, 2003
Messages
11,696
Try using the "HARDTRIM" function created by Jason in this thread and modifying it a bit.

Or you can do a series of update queries replacing 0*:
UPDATE Table1 SET Naam = Mid$([Naam],1)
WHERE Naam Like "0*";
Run this query as many times as you need it to remove all (starting) zero's. --Note For some reason i cant run this query allthough it should work.

Regards

The Mailman

P.S. Removing the leading zero's WILL be the start off sorting problems in your Table with this field.
1
1a
10
10a
100
100a
2
2a

Will be the result of an assending order by.... Just a reminder...
 
T

tsnorgaard

Guest
Thanks mate !!

Thomas
 

Users who are viewing this thread

Top Bottom