I am trying to execute a stored procedure that inserts a record<BR>one of the fields is a Numeric(11,2) field. Here is the code to <BR>create parameter.<BR><BR>Set myParm = .CreateParameter("fnd_amt", adNumeric, adParamInput, , mfnd_amt)<BR> myParm.Precision = 2<BR> myParm.NumericScale = 9 &#039 Also tried 11 here<BR><BR>When I execute the CMD object I get the following error<BR>[Microsoft][ODBC SQL Server Driver]Invalid scale value<BR><BR>Can anyone help..??<BR>Thanks Pete