>>

>>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).

Haven't used this trick much... the only time I needed it was when migrating data from dbfs to sql, and sql of course won't accept such values, so I had to catch them in advance. But the last such migration was a few years ago, so I don't really remember the details.