topic Re: Len Query in File Geodatabase in Geodatabase Questions https://community.esri.com/t5/geodatabase-questions/len-query-in-file-geodatabase/m-p/833613#M4356 <HTML><HEAD></HEAD><BODY><P>Select by attribute using Arc Map 10.1</P></BODY></HTML> Fri, 19 Aug 2016 22:14:50 GMT AbdullahAnter 2016-08-19T22:14:50Z Len Query in File Geodatabase https://community.esri.com/t5/geodatabase-questions/len-query-in-file-geodatabase/m-p/833611#M4354 <HTML><HEAD></HEAD><BODY><P>I can do len query easily in Personal geodatabase. But when I&nbsp; try to do this query in File geodatabase , appear error. Queries ex:</P><P>Len ([field]) = 13&nbsp;&nbsp;&nbsp; &nbsp; (personal geodatabase)</P><P></P><P>Len ("Field") = 13&nbsp;&nbsp;&nbsp; &nbsp;(file geodatabase)</P><P></P><P></P><P>How Can I do this query in File geodatabase?</P></BODY></HTML> Fri, 19 Aug 2016 21:24:21 GMT https://community.esri.com/t5/geodatabase-questions/len-query-in-file-geodatabase/m-p/833611#M4354 AbdullahAnter 2016-08-19T21:24:21Z Re: Len Query in File Geodatabase https://community.esri.com/t5/geodatabase-questions/len-query-in-file-geodatabase/m-p/833612#M4355 <HTML><HEAD></HEAD><BODY><P>Where are you trying to run this query?</P></BODY></HTML> Fri, 19 Aug 2016 21:42:58 GMT https://community.esri.com/t5/geodatabase-questions/len-query-in-file-geodatabase/m-p/833612#M4355 DarrenWiens2 2016-08-19T21:42:58Z Re: Len Query in File Geodatabase https://community.esri.com/t5/geodatabase-questions/len-query-in-file-geodatabase/m-p/833613#M4356 <HTML><HEAD></HEAD><BODY><P>Select by attribute using Arc Map 10.1</P></BODY></HTML> Fri, 19 Aug 2016 22:14:50 GMT https://community.esri.com/t5/geodatabase-questions/len-query-in-file-geodatabase/m-p/833613#M4356 AbdullahAnter 2016-08-19T22:14:50Z Re: Len Query in File Geodatabase https://community.esri.com/t5/geodatabase-questions/len-query-in-file-geodatabase/m-p/833614#M4357 <HTML><HEAD></HEAD><BODY><P>Try CHAR_LENGTH()</P><P></P><P><A class="link-titled" href="http://desktop.arcgis.com/en/arcmap/latest/map/working-with-layers/sql-reference-for-query-expressions-used-in-arcgis.htm" title="http://desktop.arcgis.com/en/arcmap/latest/map/working-with-layers/sql-reference-for-query-expressions-used-in-arcgis.htm">SQL reference for query expressions used in ArcGIS—Help | ArcGIS for Desktop</A>&nbsp;</P></BODY></HTML> Fri, 19 Aug 2016 22:24:02 GMT https://community.esri.com/t5/geodatabase-questions/len-query-in-file-geodatabase/m-p/833614#M4357 DarrenWiens2 2016-08-19T22:24:02Z Re: Len Query in File Geodatabase https://community.esri.com/t5/geodatabase-questions/len-query-in-file-geodatabase/m-p/833615#M4358 <HTML><HEAD></HEAD><BODY><P>or try the python parser but len would be lowercase and for file geodatabases, double-quotes or no quotes should work. &nbsp;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.</P></BODY></HTML> Fri, 19 Aug 2016 22:49:03 GMT https://community.esri.com/t5/geodatabase-questions/len-query-in-file-geodatabase/m-p/833615#M4358 DanPatterson_Retired 2016-08-19T22:49:03Z Re: Len Query in File Geodatabase https://community.esri.com/t5/geodatabase-questions/len-query-in-file-geodatabase/m-p/833616#M4359 <HTML><HEAD></HEAD><BODY><P>... of course, Select By Attribute has no Python parser... <IMG src="https://community.esri.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 19 Aug 2016 23:12:14 GMT https://community.esri.com/t5/geodatabase-questions/len-query-in-file-geodatabase/m-p/833616#M4359 DarrenWiens2 2016-08-19T23:12:14Z Re: Len Query in File Geodatabase https://community.esri.com/t5/geodatabase-questions/len-query-in-file-geodatabase/m-p/833617#M4360 <HTML><HEAD></HEAD><BODY><P>oh crap... can't wait until vb is gone and they standardize their syntax... coming soon though</P><P><A class="link-titled" href="https://pro.arcgis.com/en/pro-app/arcpy/get-started/specifying-a-query.htm" title="https://pro.arcgis.com/en/pro-app/arcpy/get-started/specifying-a-query.htm">Specifying a query in Python—ArcPy Coming to a theatre near you| ArcGIS PRO</A>&nbsp;</P></BODY></HTML> Fri, 19 Aug 2016 23:22:09 GMT https://community.esri.com/t5/geodatabase-questions/len-query-in-file-geodatabase/m-p/833617#M4360 DanPatterson_Retired 2016-08-19T23:22:09Z