Re: Using UPDATE to sequentially abbreviate address information

Iain Sharp wrote:

> On Wed, 2 Jul 2008 13:21:46 -0700 (PDT), --CELKO--
> <jcelko212@[EMAIL PROTECTED]
> wrote:
> 
>> There are address data scrubbing products from Melissa Data and Group
>> One which will do this for you and a lot more.  Do not re-invent the
>> wheel.
> 
> They look really useful. Please send me the money to buy them. 

And how much money (or equivalent labor) were you going to spend on
rolling your own?  I've never needed to do significant amounts of
address scrubbing, but if I did, I would certainly consider these
products likely to be a worthwhile investment.