English

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

Summary

The Ucase request can be used to change all characters in a string field to upper case.

Note:
The information in this article applies to 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 to be changed to upper 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 on Ucase.
  7. Click OK.
The final expression should look similar to the following:
Code:
[State_name].UCase
  1. Select Stop Editing from the Table menu.
  2. Save your edits when prompted.

Related Information