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...
 
Back
Top