Changing Case in Field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What is the update Query SQL coding to change a capitalized FILENAME to a
Fieldname? I inherited a database where all the last name and first name
fields are all in caps. I want to make them "normal."

Thanks in advance.

Jerry
 
I don't think it is necessary to write a query. Try this first. Open the
table in design view and select the
fieldname you want to correct. On the General tab associated with the field
enter
L<?????????????????????? as the Input Mask. See if that doesn't solve it.
Click to expand...

Ed G
 
Edward's suggestion will allow you to change the format -- how the value is
displayed. If you need to change the actual value stored, you can use the
StrConv() function (more recent versions of Access), or use UCase(), LCase()
and the Left(), Mid() and Right() string functions in an Update query.
 
Back
Top