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%')

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 '18 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 '18 at 20:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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