Thank you Hugo. Unfortunately I carelessly omitted the ALL from the REPLACE statement so the TRY/CATCH probably won't work for me.

Appreciate your effort...............Rich

>>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
>
>You can do something like this:
>
>

>TRY
>	REPLACE field1 WITH value2
>CATCH TO loException WHEN loException.ErrorNo = 39
>	REPLACE field1 WITH value1
>ENDTRY
>

>
>Can't think of a one-liner, also note that any other error will be raised normally
>
>[Update]I updated the code a little bit to better reflect your case[/Update]