English

How To: Convert upper case words to lower case in a string field

Summary

You can use the Lcase request to change all characters in a string field to lower case.

Note:
The information in this article applies only to retired products, ArcView GIS versions 3.x.The instructions described apply to the Avenue programming language, which is specific to the ArcView GIS application.

For ArcMap and ArcGIS Pro, this procedure can be done using a Visual Basic or Python expression. In ArcMap or Pro, open the Field Calculator, and click 'About calculating fields' for examples of field calculations.

Procedure

  1. Open the table.
  2. Select Start Editing from the Table menu.
  3. Select the field heading of the field that you want to change to lower case.
  4. Click the Field Calculator button.
    [O-Image] Field Calculator Button
  5. Double-click the field name to convert from the Fields list.
  6. Scroll down the Requests list and double-click Lcase.
  7. Click OK.
The final expression should look similar to the following:
Code:
[State_name].LCase
  1. Select Stop Editing from the Table menu.
  2. Save your edits when prompted.

Related Information