laptop and a wrench

Bug

The SQL CAST function no longer works in Select by Attributes.

Last Published: August 25, 2014 No Product Found
Bug ID Number NIM036699
SubmittedJuly 10, 2008
Last ModifiedJune 5, 2024
Applies toNo Product Found
Version found9.3
StatusWill Not Be Addressed

Additional Information

No Public Explanation

Workaround

If you use NUMERIC, at 93 you now have to give a precision and optional scale, just as you would if it were in a CREATE TABLE statement. It should be something like:CAST("field1" as NUMERIC(10,2)) > 5.7Or use the INTEGER keyword - it doesnt require scale and precision.

Steps to Reproduce

Bug ID: NIM036699

Software:

  • No Product Found

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options