UPPER CASE to Proper Case

  • Thread starter Thread starter Dale
  • Start date Start date
How do you write a query that will change UPPER CASE to Proper Case In All
Fields?

Dale
Click to expand...

By Proper Case Do You Mean Something Like This?

NewColumn:StrConv([FieldName],3)

Be aware that some words will not be properly capitalized, i.e. IBM
becomes Ibm, McDonald becomes Mcdonald, and van der Meer becomes Van
Der Meer.
 
That is exactly what I wanted. Thanks

Dale


fredg said:
How do you write a query that will change UPPER CASE to Proper Case In All
Fields?

Dale
Click to expand...

By Proper Case Do You Mean Something Like This?

NewColumn:StrConv([FieldName],3)

Be aware that some words will not be properly capitalized, i.e. IBM
becomes Ibm, McDonald becomes Mcdonald, and van der Meer becomes Van
Der Meer.
Click to expand...
 

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

Similar Threads

Changing UPPER to Proper Case 1
Update Query to change lower case to upper case 5
Need to find lower case entries in a table 2
Upper/Lower case query 4
Case-sensative query 5
Upper Case Conversion 3
conditional string conversion to mixed case 2
Case Conversion 2

Back
Top