StrConv

[shank]

I want to convert names to proper case. I'm running into a problem with
names like MacDonald, McDoogle, O'Connor, etc. The 3 character is converted
to lower case. Does anyone know of a function or a way to keep them caps? Is
it just a matter of comparing strings? I kind of doubt the phone book
companies rely on comparing.

thanks!

 

[Tom Ellison]

And there are names from some foreign languages where the first letters are
not capitalized, and there is more than one "word" in the last name: de
Shazar.

If you want to get all these correct (if there is any one correct way for
them, which there may not be) you must put all of them in a table the way
you want them. No program based on "rules" is going to get them all
correct.