Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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
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
add comment

1 Answer 1

up vote 11 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
1  
Glad to help! This might also be worth bookmarking: help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/… –  Derek Swingley Feb 11 '11 at 17:14
    
Ah soo... most helpful. Thanks again. i.imgur.com/M2ThI.jpg –  sirgeo Feb 11 '11 at 17:37
add comment

Your Answer

 
discard

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.