I am modifying a job someone else created.

I changed the following lines.

WHEN CH.CoID IN (SELECT KeyValue FROM dbo.fnValuesText(@InCo)) THEN 1

WHEN CH.CoID IN (SELECT KeyValue FROM dbo.fnValuesText(@OutCo)) THEN 0

to

WHEN CH.CoID IN (4,5,6,7) THEN 1

WHEN CH.CoID IN (8) THEN 0

This worked perfectly.

Thanks