Select to view content in your preferred language

Len Query in File Geodatabase

2026
6
Jump to solution
08-19-2016 02:24 PM
AbdullahAnter
Regular Contributor II

I can do len query easily in Personal geodatabase. But when I  try to do this query in File geodatabase , appear error. Queries ex:

Len ([field]) = 13      (personal geodatabase)

Len ("Field") = 13     (file geodatabase)

How Can I do this query in File geodatabase?

0 Kudos
1 Solution
6 Replies
DarrenWiens2
MVP Honored Contributor

Where are you trying to run this query?

0 Kudos
AbdullahAnter
Regular Contributor II

Select by attribute using Arc Map 10.1

0 Kudos
DanPatterson_Retired
MVP Emeritus

or try the python parser but len would be lowercase and for file geodatabases, double-quotes or no quotes should work.  When building the expression, it is also best not to type anything, but select elements from the dialog to get the correct spacing and syntax... see Darren's link for more details.

0 Kudos
DarrenWiens2
MVP Honored Contributor

... of course, Select By Attribute has no Python parser...

DanPatterson_Retired
MVP Emeritus

oh crap... can't wait until vb is gone and they standardize their syntax... coming soon though

Specifying a query in Python—ArcPy Coming to a theatre near you| ArcGIS PRO