>Hello All,
>We're trying to figure out if there is a decimal in a numeric field.
>After checking with type() and fsize() (with set comp off to find field size), How do we find how many decimal places there are. We are trying to avoid the use of afields() function here. We can't use str() because it seems to stop at the decimal point. We can't take the val(str(thisvalue)) and substract it because 125 - 125.00 is still 0.
>
>Any ideas would be most appreciated!!
>
>Sandy

Hi Sandy,

Look at the AFIELDS() function. The fourth column in the array contains the number of decimal places in the field.

hth,