I am trying to pass a parameter into a stored procedure that is a list of values. This list is to be used in a IN-LIST clause like so:

... WHERE SO_CD IN ('value1', 'value2', ...

The problem is if the list is a variable that is passed in like so:

... WHERE SO_CD IN (list) ...

DB2 will get tripped up because the single quotes (') are used to delimit strings.

Any suggestions? Is there any sort of escape characters I can use?

Steve