[AccessD] Design question

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




More information about the AccessD mailing list