AnsweredAssumed Answered

ArcGIS Pro: how to QUERY a text field with a numeric operator

Question asked by TSI-AR on Aug 6, 2018
Latest reply on Aug 19, 2018 by rfairhur24

I'm using an AGOL based feature layer that has all its features stored as text.  I want to use a query such as "Tot_Value >= 500000", however I get an error since Tot_Value is a text string.  I recall an earlier version of ArcMap allowed this type of operation using the same data source, so I believe it can be done.  I'm not a SQL expert, but assume I can cast this to an Int or similar, however a web search is coming up dry, and attempts on my part generate errors.  Suggestions? 

Outcomes