Removing Leading Zeros

[quietstormtw]

Hi All, I have a complete mess on my hands here.

I have been given a DB which has a column of values with leading zeros. To data is varying lengths...and also contain alpha characters.

After looking all over this forum...I could only find resolutions that solve for numeric values alone. Is there anyway to remove the leading zeros from the values that contain the alpha characters as well?

Example:

00001234
00569
0000DP8528469
00000951NW7

Any assistance is greatly appreciated!

 

[Remou]

Hi
Perhaps something like:

TheStr = "00000951NW7"

Do While Left(TheStr, 1) = 0
    TheStr = Mid(TheStr, 2)
Loop