I have a set with following values
AcctMin AcctMax MaxWithdrawalLimit 1001 1999 1000 2000 2999 2000
There is another set in which I have stored customer account number.
I would like to get AcctMin and AcctMax for a given customer account number.
Select AcctMin, AcctMax from ReferenceSet where AcctMin <= CustomerAcctNum AND AcctMax >= CustomerAcctNum.
I am using C client library. Do I need to use UDF ? I noticed that only as_int_equals or as_range options are available but for a given customer account number AcctMin and AcctMax are unknown.