The SQL CAST function no longer works in Select by Attributes.
Last Published: August 25, 2014No Product Found
Bug ID Number
NIM036699
Submitted
July 10, 2008
Last Modified
June 5, 2024
Applies to
No Product Found
Version found
9.3
Status
Will Not Be Addressed
The development team has considered the issue or request and concluded it will not be addressed. The issue's Additional Information section may contain further explanation.
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.