>>>
>>>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...
Yeah, I understand that, but some may interpret that as meaning you should use multiple REPLACE statements.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer