[RESOLVED] How to test sproc with IN operator

[conwa02976]

I am using SQL Server 2008 and I need to test a stored procedure that has an IN operator in the WHERE clause. Here is a sample query:

SELECT *
FROM tblTable
WHERE (SNum = @SNum) AND (DID IN(@DID1))

If I manually put in the parameters in the query like this:

SELECT *
FROM tblTable
WHERE (SNum = 1496) AND (DID IN(1527,1573))

then my query gets back correct results.

The problem I am having is when I try to execute the sproc from a NEW QUERY window with this command:
EXEC savedproc 1496,'1527,1573'

I get nothing in the recordset.

@SNum is an INT parameter and @DID1 is a nvarchar(100) parameter.

Thanks for any help!!