Robert,

You can test for numeric overflow in a numeric field by:

if ("*" $ transform(table1.field1))
   * numeric overflow
else
   * no overflow
endif    

>I kicked out the routine below to validate data that I am upsizing to SQL2000. There seems to be some invalid data in the tables and I want to detect it, log it and repair it.
>
>With the debugger on, I watched fields that display with all ****’s NOT fail my test. I expected “an add” to a ‘****’ field to error out. I have been out of VFP for a while and my memory does not recall how to detect invalid numeric data. I appreciate you assistance and TYIA.
>
>Robert Baker
>