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

3640
1
Jump to solution
01-23-2015 11:47 AM
shreyanemani1
New Contributor

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!

0 Kudos
1 Solution

Accepted Solutions
JoeBorgione
MVP Esteemed Contributor

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

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

That should just about do it....

View solution in original post

1 Reply
JoeBorgione
MVP Esteemed Contributor

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

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

That should just about do it....