On the SQL Server Stored Procedure I define the variable that is to receive the argument like so:<BR>CREATE PROCEDURE sp_Peak_ServiceOrderSearch @WorkOrderNumber char(10)<BR><BR>I am trying to pass an argument like so: <BR>Dim WorkOrderNumber<BR>WorkOrderNumber = "WB02275036" <BR>Set rs = cn.Execute( "{Call sp_Peak_ServiceOrderSearch(WorkOrderNumber)}" )<BR><BR>I keep getting this error: <BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039;80040e07&#039; <BR><BR>[Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification <BR><BR>/esyte/ServiceWorkOrder/sp.asp, line 57<BR><BR>Thanks in advance for your help <BR>