Sentence Case Update Query

[tomco22]

These folks at work have two "databases" on Microsoft Excel. I am converting this mess over to Access. The smaller database is ~100 names. Last, first, and middle name were all in one Excel "field". I got all that mess parsed into seperate fields but the issue I want to fix now is capitalization. Is there a way to change "SMITH" to "Smith"? This database does not have any names with double capitals such as "McDonald". The second database will have such issues because it is 15,000 names. I'll worry about that later.

Tom
MCSD
I Nab Terrorists

 

[JonFer]

Something like this should work:

Update YourTable
Set LastName=UCase(Left(LastName,1)) & LCase(Mid(LastName,2))

John

http://www.interautomateconsulting.com

 

[PHV]

You may also take a look at the StrConv function with vbProperCase(=3) argument.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[tomco22]

Thanks for the 2 responses. Worked like a charm!

Tom
MCSD
I Nab Terrorists