delete "0" before a number of strings with different length

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I'm working on a table which contains a colume with strings with
different length. some of the strings has "0" before them and I need to
delete the "0". Would anyone please tell me how to do that. Your help is
sincerely appreciated.

Here's the sample of the strings:

02365
25639
23
002563
23
6598489
0231478

and I need something like this:

2365
25639
23
2563
23
6598489
231478
 
If the values in the field are always numeric values, then you can use this
in a query.

CLng(YourField)
 
Thank you, guys. Both method works perfect. and since the values in the field
are always numeric, i took the second one. Do you have any suggestion on
reference books if I need to get myself more familiar with Access functions?

Thank you again!
 
Back
Top