[AccessD] String - strip off leading zeros

Jennifer Gross jengross at gte.net
Tue Jul 29 13:43:11 CDT 2008


Good Morning,

Does anyone have a quick function for stripping off leading zeros on a
string.  I am working with product codes, getting data from different
sources, some use leading zeros - anywhere from 1 to 5.  So, depending on
which source the data came from, the same product code could be represented
as 

1234ABC
01234ABC
001234ABC
0001234ABC
etc.

Thanks in advance,

Jennifer





More information about the AccessD mailing list