Upper/Lower case query

[Guest]

In earlier versions of Access there was a query, which I cannot remember now,
that changed all caps data into upper and lower case. It would leave the
first letter upper and change the others to lower case. Does anyone know how
to do that in Access 2007?

 

[Allen Browne]

Sounds like you used the StrConv() function, possibly in an Update query.

 

[Guest]

I don't remember what the function was but it was in an update query and it
had uc and lc in it somewhere referencing upper case and lower case. Any
more ideas on how to write the query

 

[John Spencer]

Field: Ucase(Left([SomeField,1)) & LCase(Mid(SomeField,2))

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

 

[Guest]

You don't have to update the table, you can get the same resault using a
select query using the StrConv (note: in the query you need to specify the
number of the conversion and not in word - look at the help file for examples)

Try as a new field in the query:

NewFieldName: StrConv([FieldName],3)

Or in SQL
Select TableName.* , StrConv([FieldName],3) As NewFieldName From TableName
*******

If you still want to update the table, use

Update TableName Set FieldName = StrConv([FieldName],3)