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