Convert Name field from Upper Case to Proper Case

[Jeff R]

I have a database where the last name is in all upper
case. I need to pass through the database one time and
convert the last name field to proper case.

Any suggestions on how to do this?

Thanks

Jeff...

 

[Douglas J. Steele]

Unfortunately, it's not that easy: MacDonald and Macdonald both are valid,
and what about names like von Beethoven?

There is a StrConv function you can use, with a parameter of 3:

UPDATE MyTable SET MyName = StrConv(MyName, 3)