Hello,
I would like to filter data item from a table based on select by another table used for dynamic filter criteria ... I suppose something like this below .. the values can be various ... so the select for filtering should be created dinamically.
dinamic table for filter criteria:
id From To
1 R* R*
2 C010 C010
3 T010 T030
4 ...
e.g. statically would be: select * from mytable where item = C010 or item like R* or item between T010 and T030 ... I'm asking you because maybe there is an inner functionality or macro or function to do so ...
Thanks.
Marco.