implict conversion

[Guest_imported]

Hi i had set up a db based site.. I have an editing section for the db where ican change the pricing, by simply dumping the current pricing into a form for each item, then allowing the user to either leave the old price in the form, or type a new one in.. This worked fine using an access db.. But now i put it on the net using an sql db.

It now reports:
_____________________________________________________
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 'SQL_VIDEOB0_1.SQL_VIDEOB0.Tablets', column 'ExGST1to4'. Use the CONVERT function to run this query.

/asplogon/editstockprice.asp, line 320
___________________________________________

(obviously the sql works a little different..)
so i went in and had a look at the convert function.. But i am usure how to impliment it in my code..


FOr example, one of the sql statement that reuires the convert is:

sql = "UPDATE accessory SET ExGST ='" & request.form("exgst&quot & "', IncGST ='" & request.form("incgst&quot & "',RRP ='" & request.form("rrp&quot & "' WHERE ProductCode ='" & request.form("pi&quot & "';"


so what do i do, something like

Set ExGST='cast(" & request.form("exgst&quot & " As Money)', ... ??? any ideas, or am i miles of track.?