Convert Name field from Upper Case to Proper Case


J

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...
 
Ad

Advertisements

D

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

Top