hi i all i have a requirement please look at this
select orders where field1 lies between 1000000-399999
if no orders found then select orders excluding the above crietria
i can use ranges
r_field-sign = 'I'.
r_field-option = 'BT'.
r_field-low = '100000'.
r_field-high = '399999'.
this will go for my 1select but what to do for the 2nd select where i need to
search excluding 1000000-3999999
please let me knw