>I have a table with some numeric fields with occasional asterisks in the fields meaning numeric overflow occurred. How can I search for numeric overflow asterisks and change those field values from asterisks to zeroes. I want to do a replace all one field at a time. I know how to do REPLACE ... ALL FOR ..., but it didn't work to specify MYTABLE.FIELD1 = "*" or MYTABLE.FIELD1 = whatever. What belongs after the equal sign to specify numeric overflow character? Thanks very much! I can't wait to find out this one. Beats me.
How about:
REPLACE ALL MYTABLE.FIELD1 WITH 0 FOR MAYTABLE.FIELD1 = 1 / 0?
Seems to work regardless of what actually caused the overflow.
George
Ubi caritas et amor, deus ibi est