Asp.net error when calling stored procedure

[spDavCom]

ERROR:

Implicit conversion from data type nvarchar to money is not allowed. Use the CONVERT function to run this query.

NOTE:

I'm passing a param to the stored proc from an asp.net text box or string variable.

STORED PROC:

CREATE PROCEDURE [sp_FindByAmount] @pAmount money AS
SELECT DATE, CHECK_ID, DESCRIPTION, AMOUNT, RECID
FROM tblCheckBook2000
WHERE AMOUNT = @pAmount
ORDER BY DATE
GO


QUESTION:

What must I change in the stored procedure ? and or , how do I use CONVERT , so that I can rid myself of this error??

Thank YOU, Any examples of syntax would be much appreciated.

 

[JamesLean]

Is your Amount column of data type money? If so, then calling the SP with this line should work:

EXEC sp_findbyamount 10.50

ie, don't use a char value as input:

EXEC sp_findbyamount '10.50'

--James