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 · Accepted solution]

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

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