Hello Bob,

>1. Use a soundex-type algorithm to generate an 'address code', and compare
>this new code.

Check this article for a solution based on SOUNDEX algoritm:
http://www.ibphoenix.com/a475.htm

Generally there is no easy way to solve your problem. What we do is
define a fixed address structure and use predefined lists for
all address parts that contains some name e.g. street, district, etc.

Anyway, as Helen wrote you should not hard-wire customer addresses in
order headers. Make them references.

--
Best regards,
Alexander mailto:saho@...