+ Start a Discussion
cl0s3rcl0s3r 

SOQL Fu, Where are the ninjas

I have a conundrum. I want to run a query using the Like Comparison on multiple elements, but not having much luck.  When I attempt to us "Or" logic within a "Like" comparison no records are returned.  Can someone assist?

 

SELECT Academic_Plan_Returned__c, Campus_Name__c, CreatedById, CreatedDate, Quarter__c, Student__r.Name,  Student__r.Student_Id__c FROM At_Risk__c  where Student__r.Student_Id__c != '9999' and Academic_Plan_Returned__c = true and CreatedDate > 2013-04-05T00:00:00Z and CreatedDate < 2013-05-19T00:00:00Z and Campus_Name__c like '%new port,tampa%'

Jake GmerekJake Gmerek
SELECT Academic_Plan_Returned__c, Campus_Name__c, CreatedById, CreatedDate, Quarter__c, Student__r.Name, Student__r.Student_Id__c FROM At_Risk__c where Student__r.Student_Id__c != '9999' and Academic_Plan_Returned__c = true and CreatedDate > 2013-04-05T00:00:00Z and CreatedDate < 2013-05-19T00:00:00Z and (Campus_Name__c like '%new port%' or Campus_Name__c like '%tampa%')