Hi, I wanted to make use of a range query to find out data within the range. eg. minexp : 3 maxexp: 7 if a persons exp: is between 3 and 7 then I can get his details. The problem is that if in the index the minexp or the maxexp is null/ empty i don't want to use the range query for the field which is null. that means i want to make range query only for less if maxexp is null. how can i handle this situation??? thanks in advance
Prabin
