Len Query in File Geodatabase

1092
6
Jump to solution
08-19-2016 02:24 PM
Highlighted
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?

Reply
0 Kudos
1 Solution

Accepted Solutions
Highlighted
MVP Honored Contributor
6 Replies
Highlighted
MVP Honored Contributor

Where are you trying to run this query?

Reply
0 Kudos
Highlighted
Regular Contributor II

Select by attribute using Arc Map 10.1

Reply
0 Kudos
Highlighted
MVP Honored Contributor
Highlighted
MVP Esteemed Contributor

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.

Reply
0 Kudos
Highlighted
MVP Honored Contributor

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

Highlighted
MVP Esteemed Contributor

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