Removing leading zeros

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

Guest

I have an imported table in an Access database that has a field with leading
zeros.
Some of the data contains 2 or 3 leading zeros but the field length is the
same. How can I trim these leading zeros?
 
Assuming the remainder of the data is numeric, convert it to integer (or
other numeric type) and then back to string:

CStr(Cint(SourceData))

HTH,
Barry
 
Back
Top