I am trying to select multiple (50 or more) unique numeric records using ArcGIS 10's "Select by Attributes" using semicolons ';' after each record which it verifies as good to go. Please see screen shot of where it verifies my expression "successful".

Yet when OK is hit it only selects the first record.

Do we really have to enter "xyz" = 1 OR "xyz" = 2 OR "xyz" = 3 etc. etc. to have multiple records selected?

  • 1
    Yes. That's a SQL thing, not an ArcGIS thing (since all ArcGIS is doing is sending the text as a where condition to the database server). – Michael Todd Feb 11 '11 at 17:29
  • 3
    yes better than ESRI Forums because we answer non-esri questions too - GIS is more than one company/community – Mapperz Feb 11 '11 at 18:30
  • Love this gis.stackexchange, there is so much easy-to-find Helpful information here! Very true about it being a SQL question and how GIS is so much more than Esri... if only Esri could understand that, Ha! – sirgeo Feb 11 '11 at 22:38
  • Is there any better way to do this?? Because I need to search like 400 values! – Sean Allison May 10 '18 at 18:02
  • Please create a new question with the details of what you're trying to do, what you've tried, and any issues you're running into. You can link back to this question for reference. – smiller May 10 '18 at 18:30

Use the IN operator instead:

"xyz" in (1,2,3,4,5)

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.