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?
Best Answer
Use the IN operator instead: