Hi Jeff,

I have lot of WHEN condition in the query, I have provided two conditions only in my example.

Putting WHERE (prd_cd='1' or prd_cd='2' or pr_cd='3' ) will not be correct?

Thanks!!