I have a query like this SELECT * FROM CATEGORY CAT WHERE CAT.CAT_CAT_NO =$P{employerRefNumber} Now I want to pass in cluse in where condition like SELECT * FROM CATEGORY CAT WHERE CAT.CAT_CAT_NO in ($P{employerRefNumber} ) value of employerRefNumber should be 'C001','C002' like this. Kindly guide me proper sysntex of this query in jasper report