Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
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
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
up vote 18 down vote accepted

Use the IN operator instead:

"xyz" in (1,2,3,4,5)
share|improve this answer
Works beautifully! Much Thanks Swingley! – sirgeo Feb 11 '11 at 17:10
Glad to help! This might also be worth bookmarking:… – Derek Swingley Feb 11 '11 at 17:14
Ah soo... most helpful. Thanks again. – sirgeo Feb 11 '11 at 17:37

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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