>>As a result of some processing I am getting a field with a value of ************* (numeric overflow)
>>
>>I'm not at all concerned (yet) with why this is happening (I'll fix that problem later).
>>
>>I want to do something like
>>REPLACE field1 WITH IIF(field2 is numberic overflow, value1, value2)
>>
>>What expression can I use to determine when field2 is at numeric overflow
>>
>>Thanks to all................Rich
>
>REPLACE field1 WITH IIF(field2 = 1/0, value1, value2)
Thanks Dragan.
I knew that divide by zero produced this error and I tried (at least I think I tried)
? myfield = 1/0 and kept getting false. Maybe it has something to do with the width of the field N(16).
I tried your solution in a small test and it worked so I'll look and see if it will work with my larger field.
FWIW I also found that
myField > 999999999999999999999999 also returns true for the overflow field.
As always, your help is appreciated.
.......Rich