Problem: The Select By Attributes window does not display the complete name of the layer or query clause
By design, there is a limit to the number of characters that can displayed in the dialog box.
Solution or Workaround
To resolve this issue, rename and ensure the layer name is short. In this scenario, use less than 44 characters for lower case letters and 32 characters for upper case letters.
- ArcGIS Help: Using Select By Attributes
- ArcGIS Help: Building a query expression
- ArcGIS Help: File geodatabase size and name limits.
- FAQ: What characters should not be used in ArcGIS for field names and table names?