Convert Name field from Upper Case to Proper Case

  • Thread starter Thread starter Jeff R
  • Start date Start date
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...
 
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)
 
Back
Top