>
>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.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer