I have a list of zipcodes and I want to export all records in my ORG that have that zip code. Can't I use the condition WHERE zipcode = 90802, 90803, 90804
Is my syntax wrong? Can you not do this? Why am I having trouble?
6 answers
Old post, but in case anyone finds this. This is how a WHERE condition with multiple values (OR condition) should look to function properly:
Using the example from the original post:
SELECT Id
FROM Account
WHERE
Zip Code = 'Value 1'
OR
Zip Code = 'Value 2'
OR
Zip Code = 'Value 3'
Etc. until you've added all of your values. Make sure the value is enclosed by a single quotation ' on each side.
