I can't seem to get the hang of ArcGIS Select By Attributes SQL. I'm trying to "select all that contain Street and Road and etc." Working with polyline SHP.
This works:
"NAME" LIKE ('%Street%')
This doesn't:
"NAME" LIKE ('%Street%', '%Road%')
1 Answer
This should work:
"NAME" LIKE ('%Street%') OR "NAME" LIKE ('%Road%')
-
I agree that your answer will help the OP answer the question, but I wanted to add that the parentheticals should not be required in this instance.– RobOct 10, 2018 at 19:43
-
@Rob, True enough, it would be nice if this command would work, but obviously the % wildcard doesn't work in conjunction with the IN operator but % wildcard works only when the LIKE operator is used.– BigMatOct 10, 2018 at 20:43
"NAME" LIKE '%Street% OR "NAME" LIKE '%Road%. I dont think what you are trying is possible see stackoverflow.com/questions/3014940/…