Strip leading zeros from data 1

[DanAuber]

I have a column with text data in it. Some of it is pure text and other rows are numbers. E.g.:

09768
00678
ABCDE
ABDS
0867
0223

Does anyone know of a way to strip the leading zeros from this. Thus any row that has zeros in the field at the front would be stripped (it would possibly need to cycle through a few times) - leading to:

9768
678
ABCDE
ABDS
867
223

Thanks for any help on this

Dan

 

[PHV]

Format(yourField, "#")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886