Skip to Content
0
Former Member
Sep 02, 2008 at 05:58 AM

To trim leading zeroes

39 Views

Hi,

I need to trim the leading zeroes from my field.

Eg: I am taking the field length as 6, but if my value is only of 4 digits then its coming as 004216.

I need this value to be 4216 only.

I cant change the field length to 4 as there may be values that may be more then 4 upto 6 digits.

Kindly help.

Thanks,

Manish