Jim Lawrence (AccessD)
accessd at shaw.ca
Mon Dec 13 01:22:16 CST 2004
Hi Arthur > But how many times can one spell "Mr." incorrectly? Mind you, I once read a data-cleansing > study that said the users of an app in Framingham managed to spell Boston 19 different ways. > That boggles the mind! But allegedly it's true. Just finished working on a database with schools...there must be a dozen ways to spell 'Saint' like in 'Saint Luke's' correctly and many more on how to spell it incorrectly or with subtle variations. Saint, Ste. Siant, St. Sant. Sant, St, Sainte, Sante, etc.... Cleaning up database can be as time-consuming as writing the original application. Observation Jim