Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Mahesh MMahesh M 

can any one help for how to split field values

i have one custom field i.e., Intreste_Courses__c in am given 'JAVA,Oracle,Sap' for one Record 'JAVA,Oracle,Sap,.Net' for another record so how i can seacrh only one value Like 'Java'.
if i seach with value name 'java'  i want to display related java value record.
Best Answer chosen by Mahesh M
Neetu_BansalNeetu_Bansal
Hi Mahesh,

Let suppose your field is on Account object, then you need to use the below query: 
List<Account> accountList = [ Select Id, Intreste_Courses__c from Account where Intreste_Courses__c like '%Java%' ];
This list will give you all records which contains Java into it. Please mark it as best answer if it helps you.

Thanks,
Neetu