>>So I can't mix ALL and FOR in the same REPLACE command? That's how I read it.
>
>You can, I think, but if you've got a problem, elminating that could've helped.
>
>How about:
>
>REPLACE ALL age_ymd WITH iif(arr_old.age_ymd = "Y", "YEAR(S)", iif(arr_old.age_ymd = "M", "MONTH(S)", iif(arr_old.age_ymd = "D", "DAY(S)"))) IN arrest

Little correction:

REPLACE ALL age_ymd WITH iif(arr_old.age_ymd = "Y", "YEAR(S)", iif(arr_old.age_ymd = "M", "MONTH(S)", iif(arr_old.age_ymd = "D", "DAY(S)",""))) IN arrest

Or you can use UDF in Replace, but it would be slow.
Could you please measure the time difference between scan...endscan + replace vs. replace all with complex syntax? I'm just curious, what whould be faster...

If it's not broken, fix it until it is.


My Blog