Using CONVERT function

B

Bill

I'm getting the following error:

[Microsoft][ODBC SQL Server Driver][SQL Server]Disallowed implicit
conversion from data type varchar to data type money, table
'bill.dbo.cart', column 'price'. Use the CONVERT function to run this
query.

Does anyone understand this function and how to use it? I'm trying to
pull a quantity value from one table, multiply it times a price to get
a total cost, and then stick the product into the new cart table.
However, it seems like the quantity, which was a varchar, but has
since been converted to a numeric, is still being viewed as a varchar.
Can someone help me on this?

Thanks a million,

Bill
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,995
Messages
2,570,236
Members
46,822
Latest member
israfaceZa

Latest Threads

Top