Update names that include Mc O'

  • Thread starter Thread starter DMc2004
  • Start date Start date
D

DMc2004

Hi

How can I automatically change names like have been put into lowercase, for
instance macdonald or o'brien, these should look like MacDonald and O'Brien.
How can I do this.

Many thanks

D
 
DMc2004 said:
How can I automatically change names like have been put into lowercase, for
instance macdonald or o'brien, these should look like MacDonald and O'Brien.
How can I do this.
Click to expand...


It's a whole lot more complicated than that. A person's
name is whatever they want it to be with what ever
capitalization they like. Even the "standard"
capitalization rules vary in different countries and
cultures.

For a quick and dirty (limited) approach, see:
http://www.mvps.org/access/strings/str0008.htm
 
Back
Top