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?





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)

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question