guys. i appreciate your help. if nothing else you have helped me really break the problem into more logical steps. I was just really overwhelmed first and foremost by the fact that there are 100,000 addresses in total. But you are right, between the DB (oracle 8) and some simple perl I can give them something they should be able to work with.