>>>>Hi All,
>>>>
>>>>What is the quickest way to test if a numeric table field has a decimal portion?
>>>

>>>int(field) <> field

>>
>>That tells me if the specific number in the field has a decimal portion. I need to know if the field definition itself has been set to have a decimal portion. For field type double TYPE() and VARTYPE() both return "N".
>
>What does AFIELDS return?
>
>BTW, I think I answered what you asked. You needed to be more precise in the question.

Thanks.