Editing the query text

If you want to use valid SQL expressions for which there are no command buttons, you can edit the query text directly by checking the Edit query text check box and typing the expression directly.

Steps:

1. Start ArcMap.
2. Load data in the map.
3. Right-click the layer for which you want to define a calculated specification rule and click Properties.

   The Layer Properties dialog box appears.

4. Click the Calculated Representations or Calculated Fields tab.
5. If necessary, create a new specification rule.
6. Click the SQL Statement drop-down arrow and click Edit SQL statement.

   The Query Builder dialog box appears.
7. Check the Edit query text check box.

   The SELECT, FROM, and WHERE text boxes become editable.

8. Change the text as needed in the statement.
9. Uncheck the Edit query text check box when you are finished editing the statement.
10. Click OK.
    Tip:

    You can clear the contents of the SELECT OBJECTID and WHERE fields by clicking Clear.