>>Hello everyone,
>>
>>Does anybody knows a simple way of removing 0's from a character field. Ex:
>>
>>'004'
>>
>>I want the content of the field to have '4'.
>>
>>Thanks,
>>Sergio O.
>
>Hi Sergio,
>
>Just to demonstrate that there's more than one way. If you're using VFP 6.0:
lcresult = TRANSFORM(VAL('004'))
>Only two function calls< g >.
Hi George,
I wasn't aware that the 2nd parameter was now optional. It's also different then what you get with an empty 2nd parameter. TRANSFORM(VAL('004'),'') returns ' 4.00' or however many 0's that SET DECIMAL is set to. Thanks for pointing that out.