create cursor myfilters (filters c(1)) insert into myfilters values ('>') insert into myfilters values ('#') insert into myfilters values ('=') insert into myfilters values ('<')Now, I want to run a query that use with the cursor values for filter as following:
select myfilters scan select * from mycursor where myfield <<myfilters.filters>>9 endscanBy this scan I want to get the following queries:
select * from mycursor where myfield>9 select * from mycursor where myfield#9 select * from mycursor where myfield=9 select * from mycursor where myfield<9Thank's