Is This Content Helpful?
We're glad to know this article was helpful.
*This issue has been resolved in ArcIMS 9.0.1*
The keyword UPPER is used in SPATIALQUERY to convert lowercase or mixed case field values into upper case characters. In ArcIMS 9.0, UPPER does not work for the following case:
When UPPER is used on the right side of a WHERE clause to convert mixed or lower case field values to upper case, AND the size of field value is less than the maximum allowed length of the field.
<SPATIALQUERY subfields="#ALL#" where="UPPER(WHOLEST) = UPPER('N Tryon St')" >
ArcIMS clients that use a similar query will fail to return correct results when used with an ArcIMS 9.0 Spatial Server.
The last character of field value is truncated when using UPPER. In the example shown above, the query will search for a field value that matches the string "N TRYON S".
There are two options available to workaround this issue: