Not sure why you deleted the question: Hi all, I'm trying to work out how to make my IN statement use values based on user input i.e. user inputs 'A' the in statement uses 'X','Y', user inputs 'B', statement uses 'N','M'. CC.CONTRACT_CODE IN CASE WHEN $P{AIRLINE} = 'A' THEN ('PBCA') WHEN $P{AIRLINE} = 'B' THEN ('PBCP') END AND[/code]This works but if I try to add another value i.e. CASE WHEN $P{AIRLINE} = 'A' THEN ('PBCA','PBCP') instead it won't work. Is there a better way to do this? TIA :)