• Mangesh Pawar 30
  • NEWBIE
  • 0 Points
  • Member since 2022

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 1
    Replies
Hi, 

 We have a custom object with name Territory_Lookup__c field inside this object are name, zip_start, zip_end

We have values inside this table like 
  
 Name     Zip_Start  Zip_End
 APAC           1         10
 NAM             11        20

If we pass 2 to soql it must APAC if user pass 12 it must show NAM
 
I tried below query its not working Please suggest me how to modify the query

SELECT name,zip_start,zip_end FROM territory_lookup__c where Zip_Start__c >= 2  or   Zip_End__c <=2 

Thanks
Sudhir