Hi ol! I have a stored procedure that accepts 3 parameters. When I test it in the SQL Query Analyzer using the syntax...

execute _1001 '09/01/2004', '09/30/2004, '''341-111-01'''

... I get the correct results. But when I use the following syntax in VB...

rs=cn.Execute("_1001 '09/01/2004', '09/30/2004, '''341-111-01'''")

... I get the error message...

Run-time exception thrown : System.Runtime.InteropServices.COMException - [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '341'.

Any idea on this? By the way, I am using VB.NET and ADO 2.5 not ADO.NET. My store procedure looks something like this:

CREATE PROCEDURE _1001
@DateFrom DateTime,
@DateTo DateTime,
@AcctList varchar(100)

AS

DECLARE @Sql nvarchar(4000)

SET @Sql = 'SELECT DocNo, TrnDate, AccountID, Supplier ' +
'FROM TRNPOH ' +
'WHERE AccountID IN (' + @AcctList + ')'

EXECUTE(@Sql)
GO


Thanx! in advance!!!