+ Start a Discussion

returning multiple values with SOQL statement

How can I match a multi picklist to its related values.  For instance


Object= Locations


field= Locations__c


field value= Atlanta, GA; NY,NY(NYC)


I need to return fields from the Atlanta,GA and NY,NY(NYC) Locations


I realized this was a very vague question.  I know how to do the query.  My question is how do I tell it to search for Atlanta, GA and NY,NY(NYC) as opposed to it searching for Atlanta,GA; NY,NY(NYC)