Hi Agnes,
You're welcome.
>
>thank you for pointing out this use of PADL. It seems to be the only way to get all the decimals independing of set fixed... I have searched a long time for something likethis but I have never looked that close to the function.
>
>>>
>>Try
>>lnNumber = 1.000
>>lcStr = PADL(lnNumber,20)
>>IF AT(".", lcStr) = 0
>> ? 0
>>ELSE
>> ? LEN(SUBSTR(lcStr, AT(".", lcStr)+1))
>>ENDIF
--sb--