>>>>
>>>>It should work as-is, but here are a couple notes...
>>>>You don't need reccount() - if it does not have any records, it won't have anything to scan.
>>>>Don't assign the value to a variable.
>>>>Put the code in your scan instead of calling an external routine.
>>>>REPLACE STREETNAME with SUBSTR(ADDRESS,x,x)
>>>>REPLACE STREETNO with SUBSTR(ADDRESS,x,x)
>>>>...
>>>
>>>Multiple REPLACEs will be much slower than a single REPLACE.
>>
>>The idea was to move it out of the function...
>
>In any case, with the cacheing done by VFP nowadays any difference between single/multiple REPLCEs is like there but negligible.

It's not on 1MM records. If you have record validation it would be even more noticable.