how to remove zero from the begining of a string in access by query ?

[E_Gold]

hi

how to remove zero from the begining of a string in access by query ?

for example:

00001234 -> 1234

000abc -> abc

thanks in advance

 

[John Big Booty]

Perhaps the discussion in this thread will give you some pointers.

 

[E_Gold]

thanks for the help,

but val(string) work fine only for numbers.

if i try val(A000123) i'll get 0

how to remove zero for not only numbers ?

 

[John Big Booty]

If you simply want to strip out All zeros, you could use the Replace() function.

Also the last post in the thread linked to in my previous post has some code that will only strip out leading Zeros.

 

[gemma-the-husky]

the real question is

why do you need to get the numeric value of a string? what are you using the result for?