+ Start a Discussion
acrozieracrozier 

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

acrozieracrozier

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)