SQL7 money datatype

Results 1 to 2 of 2

Thread: SQL7 money datatype

  1. #1
    Barry Guest

    Default SQL7 money datatype

    Hi all<BR>I want to insert a price into sql7&#039;s as a money datatype.<BR>When I try this , I get the following error :<BR><BR>[Microsoft][ODBC SQL Server Driver][SQL Server]Disallowed implicit conversion from data type varchar to data type money, table &#039;secondhand.dbo.product&#039;, column &#039;Price&#039;. Use the CONVERT function to run this query. <BR><BR>Please help me<BR>cheers<BR>Barry

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL7 money datatype

    Insert Into Price Values convert(money,&#039;"&yourvalue&"&#039;)...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts