Query search Question: how to specify query to results that contain 2 or more words

shreyanemani1

Q. How many of the polygons in the ___.shp have a "Type" that contains 2 or more words. Note words can be separated with either a space or a forward slash.

Count:

Select by Attributes Expression:

 

I know this can be done using the attribute table, but this is specified to displaying the expression.

 

Thank you!

JoeBorgione

  TYPE LIKE '% %'  or TYPE LIKE '%/%'

The % wild card works for File Geodatabases as well as SDE databases.  For a personal geodatabase use  the asterisk *.