If the field is numeric and you want to replace negative values with '0', then Rip's solution is correct. If the field is character then

repl Myfield with '0' for Myfield = '-' will do it.

Or, if you just want to replace the '-' with '0' but leave other characters the same, use StrTran().

HTH
Barbara

>I have a field that giving (-), I need to take this (-) and put (0) in that field, how can i do that