>Please Note: VFP 8
>
>Is there an expression which will trim leading zeros from a character expression? The expression may contain non-numeric characters.
>
>What I've come up with seems so convoluted there almost has to be a better way.
>xx="00010012012"
>? SUBSTR(xx,AT(LEFT(CHRTRAN(xx,"0",""),1),xx))
>
>Thanks to all.........Rich
Check
Re: Drop leading zeros Thread #
1383641 Message #
1383645 and the whole thread (yours).
If it's not broken, fix it until it is.
My Blog