I keep on getting this error and dont know what causes it can anyone help 

code thats causing it is below.



Microsoft OLE DB Provider for ODBC Drivers error '80040e07' 



[Microsoft][ODBC SQL Server Driver][SQL Server]Disallowed implicit 

conversion from data type varchar to data type money, table 'lodris-

ca4.lodris-ca4.sharesuser', column 'Price'. Use the CONVERT function to 

run this query. 



/lodris-ca4/listget.asp, line 67 

I am pulling last trade here which is a money field in an sql server 7 

database.

set rs = conn.execute("select LastTrade from trade where StockName = '" & 

stock & "' AND (getday =  '"& Date &  "') ") 

pricevariable = Ccur (rs("LastTrade"))



I am trying to put it into a different table here into the price field 

which is a money field also but its not working

set strSQL =conn.execute ("INSERT INTO sharesuser ( UserName, ShareOption, 

Quantity, Price, Date_bought ) VALUES ( '" & Session("strLogin") & "' ,'"& 

stock& "','" & quant & "','"& pricevariable & "','" & now() & "' )")

Thanks

Leigh