Trying to insert data into a money field in SQL Server 7.0

I am trying to insert data into a field of type money in SQL Server 7.0. The variable in my source code is defined as type currency, but when I execute the SQL statement to INSERT into the database I get a run-time error stating that I must use the SQL CONVERT command. If any one can help me PLEASE do. Thanks in advance.
TDB

I also use SQL SERVER 7 but I've never had this problem.
What's the exact SQL statement that you are trying to pass.