topic Re: Query search Question: how to specify query to results that contain 2 or more words in Geoprocessing Questions https://community.esri.com/t5/geoprocessing-questions/query-search-question-how-to-specify-query-to/m-p/709867#M23502 <HTML><HEAD></HEAD><BODY><P>&nbsp; TYPE LIKE '% %'&nbsp; or TYPE LIKE '%/%'</P><P></P><P>The % wild card works for File Geodatabases as well as SDE databases.&nbsp; For a personal geodatabase use&nbsp; the asterisk *.</P></BODY></HTML> Mon, 26 Jan 2015 16:16:32 GMT JoeBorgione 2015-01-26T16:16:32Z Query search Question: how to specify query to results that contain 2 or more words https://community.esri.com/t5/geoprocessing-questions/query-search-question-how-to-specify-query-to/m-p/709866#M23501 <HTML><HEAD></HEAD><BODY><P>Q. How many of the polygons in the ___.shp have a "Type" that contains 2 or more words. <EM>Note words can be separated with either a space or a forward slash.</EM></P><P>Count:</P><P>Select by Attributes Expression:</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>I know this can be done using the attribute table, but this is specified to displaying the expression.</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>Thank you!</P></BODY></HTML> Fri, 23 Jan 2015 19:47:04 GMT https://community.esri.com/t5/geoprocessing-questions/query-search-question-how-to-specify-query-to/m-p/709866#M23501 shreyanemani1 2015-01-23T19:47:04Z Re: Query search Question: how to specify query to results that contain 2 or more words https://community.esri.com/t5/geoprocessing-questions/query-search-question-how-to-specify-query-to/m-p/709867#M23502 <HTML><HEAD></HEAD><BODY><P>&nbsp; TYPE LIKE '% %'&nbsp; or TYPE LIKE '%/%'</P><P></P><P>The % wild card works for File Geodatabases as well as SDE databases.&nbsp; For a personal geodatabase use&nbsp; the asterisk *.</P></BODY></HTML> Mon, 26 Jan 2015 16:16:32 GMT https://community.esri.com/t5/geoprocessing-questions/query-search-question-how-to-specify-query-to/m-p/709867#M23502 JoeBorgione 2015-01-26T16:16:32Z