What I really want to do is to choose which copies to print depending on if I send the print to printer or to screen.

REPORT_COPIES.COPY_NO IN (1,2,3,6,10) This works but it sends those copies out no matter what the variable DESTYPE is.

Now
REPORT_COPIES.COPY_NO IN DECODE(:DESTYPE,'Cache',(6) ,(10))
Also works, if DESTYPE is set to 'Cache' it produces only the sixth report onto my screen, and if it is set to 'printer' report number 10 is printed.

Problem is that I want multiple pages to go out when DESTYPE is set to 'printer' and
REPORT_COPIES.COPY_NO IN DECODE(:DESTYPE,'Cache',(6) ,(1,2,3,6,10)) doesn't work at all, as the decode thinks that the comma is part of the decode.

Any suggestions for how to get around this?
Been trying with ;:.[]{} but nothing seems to work.
This is in the SQL QUERY STATEMENT that I need to get this in.