convert data to currency

[rigpig]

My dB has a column name called price and the value of currency how do you convert it to currency?

i have this in place
If Request.Form("price") = vbNullString Then
strSQL = strSQL & "0,"
Else
strSQL = strSQL & ccur(Request.Form("price")) & ","
End If
and i get this error
Disallowed implicit conversion from data type varchar to data type money, table 'ShaganappiTest.dbo.used_cars', column 'Price'. Use the CONVERT function to run this query.
I assums i Have to do something with the 0 but what....

Try the following:
If Request.Form("price") = "" Then
strSQL = strSQL & "CCur(0),"
Else
strSQL = strSQL & ccur(Request.Form("price")) & ","
End If

[rigpig]

whats wrong with this? get a syntax error the code below is for a text area

If Len (Request.Form("additional")) > 0 Then
strSQL = strSQL & AddSQLQuotes(Request.Form("additional"), "'") & ","
strSQL = strSQL & Cstr(Request.Form("additional")) & "'"
End If

<textarea rows="5" cols="68" name="additional" value="<%If VehicleID <> 0 Then Response.Write(rsData.Fields("additional")) end if%>"></textarea>

[pactalon]

If I understand you correctly, use this:


strPrice = "$" & intDollars & "." & intCents