Promes with SQL IN Clause

[c100cbk2]

I have the following code which if i replace the varaible @outputString with its literal value works fine but using the parameters fails

is there something i am missing?


WHERE (@OutputString IS NULL OR CPD.Agent_ID IN (@OutputString))

@OutputString is a varchar and looks like

'0BABEB0BF2304516BF22A4F2A4C271EB','7034E9E201DD443199DBDCADB3CFAEC2','E2F376B621E14C1FB532CED74C7EDCE1','9056F8239C8F462AB7A39B12DB8EDAA1'

 

[markros]

Check this famous (although very long) article
Arrays and Lists in SQL Server that explains how to handle lists in SQL Server. Pick up the version of the article which is for your SQL Server version.

PluralSight Learning Library