Hi..

Am working on search scenario with multiselect picklists...

For example if the field has values like  A,B,C,D.....  and the records 1 and 2 contains  1) Open,test    2) New,test within them

During Search if I Give Open,test or New,test  the Recordds are getting searched correctly.....

But the requirement is, i need to display the record  1  if i give only Open for the field instead of Open,test ...i need to work with contains functionality...

While trying to use CONTAINS(Disability__c,'Open','test','New')  am getting an error as unexpected token: ','

The Query that i used is :

orgselected = [select id,name,Organisation_Name__c,Disability__c,County__c,Age_of_Clients_Served__c,Type_of_Service__c from Organisation__c
where (CONTAINS(Disability__c,'Open','test','New'))

or
(name=:userinput.name and Disability__c =:userinput.Disability__c and County__c=:userinput.County__c and Type_of_Service__c =:userinput.Type_of_Service__c and Age_of_Clients_Served__c=:userinput.Age_of_Clients_Served__c)
or

(name=:userinput.name or Disability__c =:userinput.Disability__c or County__c=:userinput.County__c or Type_of_Service__c =:userinput.Type_of_Service__c or Age_of_Clients_Served__c=:userinput.Age_of_Clients_Served__c)];