I need some ideas, I have a MasterObject which has zip code information.
Table structure is:
98052 1000 2000 Orange County
98052 2001 3000 Deleware County
98053 1000 3000 Franklin County
if user enters 98052-1821. There are two row for 98052 but 1821 range falls between Minzip: 1000 and Maxzip: 2000.
i need to get the Orange country information. Is is possibel to write a SOQL query for this condition.
for Ex: SELECT Id, CountyName__c from MasterObject Where Zipcode = '98052' and (Minzip > '1821' and Maxzip < '1821') this is the logic i am expecting.