ARG.CENTRE_CODE_COLUMN IN (select center_code from table_center_codes)
You cannot use IN and = together.
Thanks for the reply. Could you please tell me How use trim operation to avoid any spaces before or after center_codes(If someone mistakenly enter spaces with contercodes).
About the Trim, you can use it like this:
Rtrim(Field) it removes spaces from right
Ltrim(Field) it removes spaces from left
Rtrim(Ltrim(Field)) it removes from both sides
ps: use it in the target expression.
Rtrim(Ltrim(ARG.CENTRE_CODE_COLUMN IN (select center_code from table_center_codes)))
Or ARG.CENTRE_CODE_COLUMN IN (Rtrim(Ltrim(select center_code from table_center_codes)))