Integer to String "on-the-fly" conversion in ArcGIS
Posted 17 June 2009 - 09:01 AM
I'd like to query an integer field in Arc to find some "numeric" characters...
I'd like to use this query (from MapInfo) into ArcGIS : RIGHT$(Str$(Field),2)
The "Right" part is basic, but I can't find the equivalent of the Str$ command in Arc...
Posted 18 June 2009 - 06:09 AM
AFAIK there's no VBA support in SQL queries in ArcGIS. You would have to derive a new field with the computed values first.
Oh yeah, you're right!!!
Is there a way to do this directly in SQL?
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users