How to remove spaces
Posted on 2006-10-28
i am trying to removes spaces in a name field.
some of the names are just like
John Jones., but with 2 spaces like John Jones
then some are like
John J Jones
that is with 2 spaces after the middle initial
and then some are like
John J Jones., where there are 2 spaces in front of the middle initial.
Some of the initials have periods after them, some do not.
what i am trying to do is get the duplicates out of a mailing list..
but using just a regualr find duplicate query does not work.
any ideas ?
all of these are in one table in MS Access 2003