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 1


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.
    – Rob
    Oct 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.
    – BigMat
    Oct 10, 2018 at 20:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.