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). Commented Feb 11, 2011 at 17:29
  • 3
    yes better than ESRI Forums because we answer non-esri questions too - GIS is more than one company/community
    – Mapperz
    Commented Feb 11, 2011 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
    Commented Feb 11, 2011 at 22:38
  • Is there any better way to do this?? Because I need to search like 400 values! Commented May 10, 2018 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
    Commented May 10, 2018 at 18:30

1 Answer 1


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 and acknowledge you have read our privacy policy.

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