Microsoft Access Database - I have a mailing list of approximately 41,000 names.

[peacock97]

I received this database originally in UPPER CASE letters. When I convered to lower case, with the 1st letter being UPPER CASE, everything worked fine except that all the MacDonalds, McIntyres and MacInnis came out as Macdonald, Mcintyre and Macinnis.

How do I fix this so that the 3rd or 4th letter is UPPER CASE.

[MMcCarthy]

Run a replace to replace "Mac" with "Mac " and "Mc" with "Mc ". Then if you run the converstion to Sentence case again it should work.