Remove first four zeros!

[arneweise77]

Hi!

I need to solve this problem!
When displaying a text, let´s say 0000478564, I need to remove or in some way get rid of the first 4 zeros.
Is there a function for this in access? or should I do this in my code(ASP.NET)

 

[gwinn7]

Yes, example...

MyString = mid("0000478564",5,Len("0000478564&quot-4)

Gary
gwinn7
A+, Network+

 

[LittleSmudge]

Can you really guarantee that it will ALWAYS be FOUR zeros ?


If, as I suspect, the future holds the potential prospect of a different number of zeros then use:-

strOriginal = the original string ( "0000478564" ) in your example


While InStr(strOriginal,"0&quot = 1
strOriginal = Right(strOriginal, Len(strOriginal) - 1 )
Wend



QED.

G LS