>>Hi Trey....
>>?round(my_currency_fld,12) = 0 ...returns .F....round(my_currency_fld,12) = 0 returns .T. if there is a zero in the fld and it returns a false it anything else is in the field... round() does not help this situation....thanks...:)
>
>OK - I see what you're after.
>
>There is no such thing as an "empty" non-character field the way you are speaking of it. i.e., When you look at the value in the field, it has 0's.
>If you browse the table, go to a currency field in an existing record highlight the field contents, hit delete, tab to another field - the currency field will now have 0.000 in it.
>
>Any number type field (numeric, integer, double, currency, etc.) is initialized to 0 for new records.
>
>I should have specified EMPTY() for numerics (numeric, integer, double, currency, etc.) means the lowest possible absolute value - that would be 0.
>
>What else would it be if not 0? The only other possibility you have is .NULL.
****************
you got it....ISNULL is the answering I need.... thanks ....:))))